{"text_format":"3","workbook":"xlsx","n_sheets":26,"sheets":["ТИТУЛ","ОГЛАВЛЕНИЕ","Список группы","РР-1","РР-2","РР-3","РР-4","ИТОГ РР","ПР-1","ПР-2","ИТОГ ПР","СК-1","СК-2","СК-3","ИТОГ СК","ХЭ-1","ХЭ-2","ХЭ-3","ХЭ-4","ХЭ-5","ИТОГ ХЭ","ФР-1","ФР-2","ИТОГ ФР","ОБЩИЙ ИТОГ","Инд.показатели"],"not_rendered":{"charts":64,"images":8},"read":"whole","date_system":"1900"}

{"sheet":"ТИТУЛ","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[9,0,9,8],[11,0,11,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[21,0,21,2],[21,3,21,6],[22,0,22,2],[22,3,22,6],[23,0,23,2],[23,3,23,6],[24,0,24,2],[24,3,24,6]]}
["НАИМЕНОВАНИЕ УЧРЕЖДЕНИЯ"]
{"$rows_empty":8}
["Диагностика индивидуального развития детей 3-4 лет с ТНР"]
[]
["20__-20___ учебный год"]
[]
["В соответствии с Федеральной адаптированной образовательной"]
["программой дошкольного образования"]
["Приказ Министерства просвещения РФ от 24.11.2022г."]
[]
[]
[]
["Педагоги:"]
[]
["Воспитатель:"]
["Воспитатель:"]
["Учитель-логопед:"]
["Муз.руководитель"]

{"sheet":"ОГЛАВЛЕНИЕ","index":1,"n_rows":34,"n_cols":2,"rows_kept":34,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,0,3,8],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,0,9,8],[10,1,10,7],[11,1,11,7],[12,1,12,7],[13,0,13,8],[14,0,15,0],[14,1,15,7],[16,0,17,0],[16,1,17,7],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,0,21,8],[22,1,22,7],[23,1,23,7],[24,1,24,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[28,0,28,8],[29,1,29,7],[30,1,30,7],[31,1,31,7],[33,1,33,7]]}
[null,"ОГЛАВЛЕНИЕ:"]
[null,"Кликнув мышкой по соответствующему названию, вы автоматически перейдете в нужный раздел."]
["наименование вкладки","ТИТУЛЬНЫЙ ЛИСТ"]
["Образовательная область \"Речевое  развитие\""]
["РР-1","НАПРАВЛЕНИЕ I. ФОРМИРОВАНИЕ СЛОВАРЯ"]
["РР-2","НАПРАВЛЕНИЕ 2. ЗВУКОВАЯ КУЛЬТУРА РЕЧИ. ПОДГОТОВКА К ОБУЧЕНИЮ ГРАМОТЕ"]
["РР-3","НАПРАВЛЕНИЕ 3. ГРАММАТИЧЕСКИЙ СТРОЙ РЕЧИ."]
["РР-4","НАПРАВЛЕНИЕ 4. СВЯЗНАЯ РЕЧЬ. ИНТЕРЕС К ХУДОЖЕСТВЕННОЙ ЛИТЕРАТУРЕ"]
["ИТОГ РР","Обобщение результатов педагогической диагностики по направлениям ОО \"Речевое развитие\""]
["Образовательная область \"Познавательное развитие\""]
["ПР-1","НАПРАВЛЕНИЕ 1. СЕНСОРНЫЕ ЭТАЛОНЫ И ПОЗНАВАТЕЛЬНЫЕ ДЕЙСТВИЯ. ОКРУЖАЮЩИЙ МИР. ПРИРОДА."]
["ПР-2","НАПРАВЛЕНИЕ 2. МАТЕМАТИЧЕСКИЕ ПРЕДСТАВЛЕНИЯ"]
["ИТОГ -ПР","Обобщение результатов педагогической диагностики по направлениям ОО \"Познавательное развитие\""]
["Образовательная область \"Социально-коммуникативное развитие\""]
["СК-1","НАПРАВЛЕНИЕ 1. СОЦИАЛЬНЫЕ ОТНОШЕНИЯ."]
[]
["СК-1","НАПРАВЛЕНИЕ 2. ФОРМИРОВАНИЕ ОСНОВ ГРАЖДАНСТВЕННОСТИ И ПАРТИОТИЗМА."]
[]
["СК-2","НАПРАВЛЕНИЕ 3. ТРУДОВОЕ ВОСПИТАНИЕ"]
["СК-3","НАПРАВЛЕНИЕ 4. ФОРМИРОВАНИЕ БЕЗОПАСНОГО ПОВЕДЕНИЯ"]
["ИТОГ СК","Обобщение результатов педагогической диагностики по направлениям ОО \"Социально-коммуникативное развитие\""]
["Образовательная область \"Художественно-эстетическое развитие\""]
["ХЭ-1","НАПРАВЛЕНИЕ I. ПРИОБЩЕНИЕ К ИСКУССТВУ"]
["ХЭ-2","НАПРАВЛЕНИЕ 2. КОНСТРУКТИВНАЯ ДЕЯТЕЛЬНОСТЬ"]
["ХЭ-3","НАПРАВЛЕНИЕ 3. ИЗОБРАЗИТЕЛЬНАЯ ДЕЯТЕЛЬНОСТЬ"]
["ХЭ-4","НАПРАВЛЕНИЕ 4. МУЗЫКАЛЬНАЯ ДЕЯТЕЛЬНОСТЬ"]
["ХЭ-5","НАПРАВЛЕНИЕ 5. ТЕАТРАЛИЗОВАННАЯ И КУЛЬТУРНО-ДОСУГОВАЯ ДЕЯТЕЛЬНОСТЬ"]
["ИТОГ ХЭ","Обобщение результатов педагогической диагностики по направлениям ОО \"Художественно-эстетическое развитие\""]
["Образовательная область \"Физическое развитие\""]
["ФР-1","НАПРАВЛЕНИЕ I. ОСНОВНАЯ ГИМНАСТИКА. ПОДВИЖНЫЕ И СПОРТИВНЫЕ ИГРЫ. СПОРТИВНЫЕ УПРАЖНЕНИЯ"]
["ФР-2","НАПРАВЛЕНИЕ 2. ФОРМИРОВАНИЕ ОСНОВ ЗДОРОВОГО ОБРАЗА ЖИЗНИ. АКТИВНЫЙ ОТДЫХ"]
["ИТОГ ФР","Обобщение результатов педагогической диагностики по направлениям ОО «Физическое развитие»"]
[]
["ОБЩИЙ ИТОГ","Обобщение результатов педагогической диагностики по всем образовательным областям "]

{"sheet":"Список группы","index":2,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[0,0,0,4]]}
["Список обучающихся"]
[]
[null,"№п/п","Фамилия имя ребенка","Возраст","Заключение "]
[null,1,"Бахтин Антон"]
[null,2,"Башилова Наталья"]
[null,3,"Бирюкова Екатерина"]
[null,4,"Власов Дмитрий"]
[null,5,"Гущина Софья"]
[null,6,"Десятниченко Кирилл"]
[null,7,"Йолсал Дениз"]
[null,8,"Кирилина Виктория"]
[null,9,"Князева Алиса"]
[null,10,"Максимова Анна"]
[null,11,"Меньшов Алексей"]
[null,12,"Муравлев Даниил"]
[null,13,"Панов Тимофей "]
[null,14,"Саркисов Илья "]
[null,15,"Свирская Анастасия "]
[null,16,"Семенина Елизавета"]
[null,17,"Сергеев Алексей"]
[null,18,"Солопов Максим"]
[null,19,"Стригунов Александр "]
[null,20,"Тихонов Данил"]
[null,21,"Федоров Данила"]
[null,22,"Чалдина Дарья"]
[null,23,"Черногоров Аркадий "]
[null,24,"Шагабудинов Владислав "]

{"sheet":"РР-1","index":3,"n_rows":41,"n_cols":22,"rows_kept":41,"merged":[[0,0,0,21],[1,20,1,21],[3,0,5,0],[3,1,5,1],[3,2,3,7],[3,8,3,13],[3,14,3,19],[3,20,4,21],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,17],[4,18,4,19]]}
["Образовательная область «Речевое развитие»"]
["НАПРАВЛЕНИЕ I. ФОРМИРОВАНИЕ СЛОВАРЯ",{"$nulls":19},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Понимает и использует в речи обобщающие слова",{"$nulls":5},"Понимает и употребляет слова, обозначающие название",{"$nulls":5},"Понимает и использует в речи",{"$nulls":5},"среднее значение "]
[null,null,"игрушки",null,"посуда",null,"одежда",null,"предметов (по картинками) - стол, стул, окно, голова, рука, нос, уши, глаза",null,"действий (где мальчик стоит, идет, сидит, играет?)",null,"признаков (называет предьявленные цвета)",null,"существительные",null,"глаголы",null,"прилагательные"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"$f":"(C7+E7+G7+I7+K7+M7+O7+Q7+S7)/9","v":{"v":3.2222222222222223,"d":"3.22"}},{"$f":"(D7+F7+H7+J7+L7+N7+P7+R7+T7)/9","v":{"v":4.222222222222222,"d":"4.22"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,{"$f":"(C8+E8+G8+I8+K8+M8+O8+Q8+S8)/9","v":{"v":2.888888888888889,"d":"2.89"}},{"$f":"(D8+F8+H8+J8+L8+N8+P8+R8+T8)/9","v":{"v":3.888888888888889,"d":"3.89"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,{"v":3.6666666666666665,"d":"3.67"},{"v":2.5555555555555554,"d":"2.56"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,{"v":3.6666666666666665,"d":"3.67"},{"v":2.5555555555555554,"d":"2.56"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,{"v":3.6666666666666665,"d":"3.67"},{"v":2.5555555555555554,"d":"2.56"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,{"v":3.6666666666666665,"d":"3.67"},{"v":2.5555555555555554,"d":"2.56"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,{"v":3.6666666666666665,"d":"3.67"},{"v":2.5555555555555554,"d":"2.56"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,{"v":3.6666666666666665,"d":"3.67"},{"v":2.5555555555555554,"d":"2.56"}]
[null,"среднее значение:",{"$f":"SUM(C7:C30)/(COUNTA($B$7:$B$30)-COUNTIF($B$7:$B$30,\"=0\"))","v":3.25},{"$f":"SUM(D7:D30)/(COUNTA($B$7:$B$30)-COUNTIF($B$7:$B$30,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},3.75,4.25,3.75,{"v":4,"d":"4.00"},{"v":3.6944444444444446,"d":"3.69"},{"v":3.9166666666666665,"d":"3.92"}]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$7:$B$30)-COUNTIF($B$7:$B$30,\"=0\")","v":24},{"$f":"COUNTIF($U$7:$U$30,\">=3,8\")","v":6},{"$f":"COUNTIFS($U$7:$U$30,\"<3,7\",$U$7:$U$30,\">=2,3\")","v":18},{"$f":"COUNTIFS($U$7:$U$30,\"<2,2\",$U$7:$U$30,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":25,"d":"25.0"}},{"$f":"E35*C36/C35","v":{"v":75,"d":"75.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}}]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$7:$B$30)-COUNTIF($B$7:$B$30,\"=0\")","v":24},{"$f":"COUNTIF($V$7:$V$30,\">=3,8\")","v":18},{"$f":"COUNTIFS($V$7:$V$30,\"<3,7\",$V$7:$V$30,\">=2,3\")","v":6},{"$f":"COUNTIFS($V$7:$V$30,\"<2,2\",$V$7:$V$30,\">0\")","v":0}]
[null,"%",100,{"$f":"D40*C41/C40","v":{"v":75,"d":"75.0"}},{"$f":"E40*C41/C40","v":{"v":25,"d":"25.0"}},{"$f":"F40*C41/C40","v":{"v":0,"d":"0.0"}}]

{"sheet":"РР-2","index":4,"n_rows":42,"n_cols":18,"rows_kept":42,"merged":[[0,16,0,17],[2,0,4,0],[2,1,4,1],[2,2,3,3],[2,4,2,9],[2,10,3,11],[2,12,3,13],[2,14,3,15],[2,16,3,17],[3,4,3,5],[3,6,3,7],[3,8,3,9]]}
["НАПРАВЛЕНИЕ 2. ЗВУКОВАЯ КУЛЬТУРА РЕЧИ. ПОДГОТОВКА К ОБУЧЕНИ ГРАМОТЕ.",{"$nulls":15},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Произносит простые по артикуляции звуки",null,"Воспроизводит звуковлоговую структуру",{"$nulls":5},"Различает на слух длинные и короткие слова",null,"Вслушивается в звучание слова",null,"Владеет терминами \"слово\", \"звук\"",null,"среднее значение "]
[{"$nulls":4},"односложных слов (дом, кот, дуб, бук, мак)",null,"двусложных слов (вода,нога, вата, Дима)",null,"трехсложных слов (вагоны, бананы, батоны, панама)"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"$f":"(C6+E6+G6+I6+K6+M6+O6)/7","v":{"v":3.2857142857142856,"d":"3.29"}},{"$f":"(D6+F6+H6+J6+L6+N6+P6)/7","v":{"v":4.285714285714286,"d":"4.29"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"$f":"(C7+E7+G7+I7+K7+M7+O7)/7","v":{"v":2.7142857142857144,"d":"2.71"}},{"$f":"(D7+F7+H7+J7+L7+N7+P7)/7","v":{"v":3.7142857142857144,"d":"3.71"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,"среднее значение:",{"$f":"SUM(C6:C29)/(COUNTA($B$6:$B$29)-COUNTIF(B6:B29,\"=0\"))","v":3.25},{"$f":"SUM(D6:D29)/(COUNTA($B$6:$B$29)-COUNTIF(C6:C29,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},{"v":3.6785714285714284,"d":"3.68"},{"v":3.857142857142857,"d":"3.86"}]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF(Q6:Q29,\">=3,8\")","v":6},{"$f":"COUNTIFS(Q6:Q29,\"<3,7\",Q6:Q29,\">=2,3\")","v":12},{"$f":"COUNTIFS(Q6:Q29,\"<2,2\",Q6:Q29,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":25,"d":"25.0"}},{"$f":"E35*C36/C35","v":{"v":50,"d":"50.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF(R6:R29,\">=3,8\")","v":12},{"$f":"COUNTIFS(R6:R29,\"<3,7\",R6:R29,\">=2,3\")","v":6},{"$f":"COUNTIFS(R6:R29,\"<2,2\",R6:R29,\">0\")","v":0}]
[null,"%",100,{"$f":"D41*C42/C41","v":{"v":50,"d":"50.0"}},{"$f":"E41*C42/C41","v":{"v":25,"d":"25.0"}},{"$f":"F41*C42/C41","v":{"v":0,"d":"0.0"}}]

{"sheet":"РР-3","index":5,"n_rows":42,"n_cols":26,"rows_kept":42,"merged":[[0,24,0,25],[2,0,4,0],[2,1,4,1],[2,2,2,5],[2,6,3,7],[2,8,2,11],[2,12,2,19],[2,20,2,23],[2,24,3,25],[3,2,3,3],[3,4,3,5],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19],[3,20,3,21],[3,22,3,23]]}
["НАПРАВЛЕНИЕ 3. ГРАММАТИЧЕСКИЙ СТРОЙ РЕЧИ",{"$nulls":23},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Образует и использует в речи существительные (по картинкам)",{"$nulls":3},"Умеет согласовывать прилагательные с сущ-ми ед.числа м.р. и ж.р. (красный мяч, синий шар, красная чашка, синяя лопатка)",null,"Употребляет предложно-падежные конструкции с предлогами (по картинкам)",{"$nulls":3},"Использует в речи сущ-ые с уменьшительно-ласкат.суффиксами (по картинкам)",{"$nulls":7},"Правильно употребляет в речи глаголы ед. и мн.числа (по картинкам)",{"$nulls":3},"среднее значение "]
[null,null,"в Иминительном падеже, ед. и мн.числа (стол-столы, мяч-мячи, дом-дома, куала-куклы, рука-руки) ",null,"в Винительном падеже без предлога (Что ты видишь? - вижу дом, машину, куклу)",{"$nulls":3},"В",null,"НА",null,"дом-домик",null,"стул-стульчик",null,"чашка-чашечка",null,"кукла-куколка",null,"кот спит - коты спят",null,"птичка летит - птички летят"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"$f":"(C6+E6+G6+I6+K6+M6+O6+Q6+S6+U6+W6)/11","v":{"v":3.1818181818181817,"d":"3.18"}},{"$f":"(D6+F6+H6+J6+L6+N6+P6+R6+T6+V6+X6)/11","v":{"v":4.181818181818182,"d":"4.18"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,4,5,{"$f":"(C7+E7+G7+I7+K7+M7+O7+Q7+S7+U7+W7)/11","v":{"v":3,"d":"3.00"}},{"$f":"(D7+F7+H7+J7+L7+N7+P7+R7+T7+V7+X7)/11","v":{"v":4,"d":"4.00"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,4,5,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,4,5,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,4,5,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,4,5,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,4,5,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[null,"среднее значение:",{"$f":"SUM(C6:C29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":3.25},{"$f":"SUM(D6:D29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},3.75,4.25,3.75,{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},4.25,{"v":3.727272727272727,"d":"3.73"},{"v":3.9545454545454546,"d":"3.95"}]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($Y$6:$Y$29,\">=3,8\")","v":6},{"$f":"COUNTIFS($Y$6:$Y$29,\"<3,7\",$Y$6:$Y$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($Y$6:$Y$29,\"<2,2\",$Y$6:$Y$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":25,"d":"25.0"}},{"$f":"E35*C36/C35","v":{"v":50,"d":"50.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($Z$6:$Z$29,\">=3,8\")","v":18},{"$f":"COUNTIFS($Z$6:$Z$29,\"<3,7\",$Z$6:$Z$29,\">=2,3\")","v":6},{"$f":"COUNTIFS($Z$6:$Z$29,\"<2,2\",$Z$6:$Z$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D41*C42/C41","v":{"v":75,"d":"75.0"}},{"$f":"E41*C42/C41","v":{"v":25,"d":"25.0"}},{"$f":"F41*C42/C41","v":{"v":0,"d":"0.0"}}]

{"sheet":"РР-4","index":6,"n_rows":42,"n_cols":19,"rows_kept":42,"merged":[[0,14,0,16],[2,1,4,1],[2,2,4,2],[2,3,3,4],[2,5,3,6],[2,7,3,8],[2,9,3,10],[2,11,3,12],[2,13,3,14],[2,15,3,16],[2,17,3,18]]}
[null,"НАПРАВЛЕНИЕ 4. СВЯЗНАЯ РЕЧЬ. ИНТЕРЕС К ХУДОЖЕСТВЕННОЙ ЛИТЕРАТУРЕ",{"$nulls":12},"ОГЛАВЛЕНИЕ"]
[]
[null,"№п/п","ФИ ребенка","Рассказывает двустишья",null,"Отвечает на вопросы после прочтения сказки, используя слова, простые предложения, состоящие из двух-трех слов",null,"Передает содержание знакомой сказки по серии картинок с помощью педагога",null,"Внятно, не спеша произносит небольшие потешки и стихотворения",null,"Воспроизводит короткие ролевые диалоги из сказок и прибауток в играх-драматизациях",null,"Эмоционально откливаектся на процесс совместного слушания художественных произведений (улыбка, смех, жесты)",null,"Понимает содержание и композицию текста (поступки персонажы, последовательность событий)",null,"среднее значение "]
[]
[{"$nulls":3},"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[null,1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"$f":"(D6+F6+H6+J6+L6+N6+P6)/7","v":{"v":3.2857142857142856,"d":"3.29"}},{"$f":"(E6+G6+I6+K6+M6+O6+Q6)/7","v":{"v":4.285714285714286,"d":"4.29"}}]
[null,2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"$f":"(D7+F7+H7+J7+L7+N7+P7)/7","v":{"v":2.7142857142857144,"d":"2.71"}},{"$f":"(E7+G7+I7+K7+M7+O7+Q7)/7","v":{"v":3.7142857142857144,"d":"3.71"}}]
[null,3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[null,6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[null,7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[null,10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[null,11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[null,14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[null,15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[null,18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[null,19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":3.2857142857142856,"d":"3.29"},{"v":4.285714285714286,"d":"4.29"}]
[null,22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,{"v":2.7142857142857144,"d":"2.71"},{"v":3.7142857142857144,"d":"3.71"}]
[null,23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,{"v":3.7142857142857144,"d":"3.71"},{"v":2.4285714285714284,"d":"2.43"}]
[null,null,"среднее значение:",{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\"))","v":3.25},{"v":3.5,"d":"3.50"},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},{"v":3.6785714285714284,"d":"3.68"},{"v":3.857142857142857,"d":"3.86"}]
[]
[]
[null,null,"начало года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\")","v":24},{"$f":"COUNTIF($R$6:$R$29,\">=3,8\")","v":6},{"$f":"COUNTIFS($R$6:$R$29,\"<3,7\",$R$6:$R$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($R$6:$R$29,\"<2,2\",$R$6:$R$29,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E35*D36/D35","v":{"v":25,"d":"25.0"}},{"$f":"F35*D36/D35","v":{"v":50,"d":"50.0"}},{"$f":"G35*D36/D35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,null,"конец года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\")","v":24},{"$f":"COUNTIF($S$6:$S$29,\">=3,8\")","v":12},{"$f":"COUNTIFS($S$6:$S$29,\"<3,7\",$S$6:$S$29,\">=2,3\")","v":6},{"$f":"COUNTIFS($S$6:$S$29,\"<2,2\",$S$6:$S$29,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E41*D42/D41","v":{"v":50,"d":"50.0"}},{"$f":"F41*D42/D41","v":{"v":25,"d":"25.0"}},{"$f":"G41*D42/D41","v":{"v":0,"d":"0.0"}}]

{"sheet":"ИТОГ РР","index":7,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[0,0,0,5],[1,0,1,5],[29,0,29,1],[29,2,29,5],[30,2,30,5],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[37,0,37,1],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5]]}
["Обобщение результатов педагогической диагностики по направлениям"]
["ОО «Речевое развитие»"]
[{"$nulls":5},"ОГЛАВЛЕНИЕ"]
[]
[null,"Формирование словаря","Звуковая культура речи. Обучение грамоте ","Грамматический строй речи","Связная речь. Интерес к художественной литературе","Средний уровень речевого развития"]
[null,1,2,3,4,"ср.ур."]
["начало",{"$f":"'РР-1'!$U$31","v":{"v":3.6944444444444446,"d":"3.69"}},{"$f":"'РР-2'!Q30","v":{"v":3.6785714285714284,"d":"3.68"}},{"$f":"'РР-3'!Y30","v":{"v":3.727272727272727,"d":"3.73"}},{"$f":"'РР-4'!R30","v":{"v":3.6785714285714284,"d":"3.68"}},{"$f":"(B7+C7+D7+E7)/4","v":{"v":3.6947150072150072,"d":"3.69"}}]
["конец",{"$f":"'РР-1'!$V$31","v":{"v":3.9166666666666665,"d":"3.92"}},{"$f":"'РР-2'!R30","v":{"v":3.857142857142857,"d":"3.86"}},{"$f":"'РР-3'!Z30","v":{"v":3.9545454545454546,"d":"3.95"}},{"$f":"'РР-4'!S30","v":{"v":3.857142857142857,"d":"3.86"}},{"$f":"(B8+C8+D8+E8)/4","v":{"v":3.896374458874459,"d":"3.90"}}]
{"$rows_empty":20}
["ВЫВОДЫ:"]
["Начало учебного года:"]
{"$rows_empty":7}
["Конец учебного года:"]

{"sheet":"ПР-1","index":8,"n_rows":43,"n_cols":26,"rows_kept":43,"merged":[[0,0,0,25],[2,24,2,25],[4,0,6,0],[4,1,6,1],[4,2,5,3],[4,4,5,5],[4,6,5,7],[4,8,5,9],[4,10,5,11],[4,12,4,19],[4,20,5,21],[4,22,5,23],[4,24,5,25],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19]]}
["Образовательная область «Познавательное развитие»"]
[]
["НАПРАВЛЕНИЕ 1. СЕНСОРНЫЕ ЭТАЛОНЫ И ПОЗНАВАТЕЛЬНЫЕ ДЕЙСТВИЯ. ОКРУЖАЮЩИЙ МИР. ПРИРОДА.",{"$nulls":23},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Различает и называет цвета (красный, синий, зеленый, желтый, белый, черный)",null,"Называет оттенки цветов (розовый, голубой, серый).",null,"Различает круг, квадрат, треугольник, предметы, имеющие углы и круглую форму",null,"Знает названия нескольких профессий и их действий",null,"Собирает простые предметные картинки из двух-трех частей (без помощи взрослого)",null,"Знает и называет",{"$nulls":7},"Соотносит предмет, изображенный на  картинке, по описанию педагога",null,"Знает правила поведения в природе (не ломать ветки, не рвать растения, быть осторожными с животными)",null,"среднее значение "]
[{"$nulls":12},"игрушки",null,"одежда",null,"обувь",null,"посуда"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"$f":"(C8+E8+G8+I8+K8+M8+O8+Q8+S8+U8+W8)/11","v":{"v":3.1818181818181817,"d":"3.18"}},{"$f":"(D8+F8+H8+J8+L8+N8+P8+R8+T8+V8+X8)/11","v":{"v":4.181818181818182,"d":"4.18"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"$f":"(C9+E9+G9+I9+K9+M9+O9+Q9+S9+U9+W9)/11","v":{"v":2.909090909090909,"d":"2.91"}},{"$f":"(D9+F9+H9+J9+L9+N9+P9+R9+T9+V9+X9)/11","v":{"v":3.909090909090909,"d":"3.91"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":2.909090909090909,"d":"2.91"},{"v":3.909090909090909,"d":"3.91"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":2.909090909090909,"d":"2.91"},{"v":3.909090909090909,"d":"3.91"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":2.909090909090909,"d":"2.91"},{"v":3.909090909090909,"d":"3.91"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":2.909090909090909,"d":"2.91"},{"v":3.909090909090909,"d":"3.91"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,3,4,{"v":3.1818181818181817,"d":"3.18"},{"v":4.181818181818182,"d":"4.18"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":2.909090909090909,"d":"2.91"},{"v":3.909090909090909,"d":"3.91"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,4,3,{"v":3.727272727272727,"d":"3.73"},{"v":2.6363636363636362,"d":"2.64"}]
[null,"среднее значение:",{"$f":"(C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29+C30+C31)/(COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\"))","v":3.25},{"$f":"(D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29+D30+D31)/(COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},3.75,4.25,3.75,{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"},{"v":3.7045454545454546,"d":"3.70"},{"v":3.9318181818181817,"d":"3.93"}]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\")","v":24},{"$f":"COUNTIF(Y8:Y31,\">=3,8\")","v":6},{"$f":"COUNTIFS(Y8:Y31,\"<3,7\",Y8:Y31,\">=2,3\")","v":12},{"$f":"COUNTIFS(Y8:Y31,\"<,2,2\",Y8:Y31,\">0\")","v":0}]
[null,"%",100,{"$f":"D36*C37/C36","v":{"v":25,"d":"25.0"}},{"$f":"E36*C37/C36","v":{"v":50,"d":"50.0"}},{"$f":"F36*C37/C36","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\")","v":24},{"$f":"COUNTIF(Z8:Z31,\">=3,8\")","v":18},{"$f":"COUNTIFS(Z8:Z31,\"<3,7\",Z8:Z31,\">=2,3\")","v":6},{"$f":"COUNTIFS(Z8:Z31,\"<2,2\",Z8:Z31,\">0\")","v":0}]
[null,"%",100,{"$f":"D42*C43/C42","v":{"v":75,"d":"75.0"}},{"$f":"E42*C43/C42","v":{"v":25,"d":"25.0"}},{"$f":"F42*C43/C42","v":{"v":0,"d":"0.0"}}]

{"sheet":"ПР-2","index":9,"n_rows":42,"n_cols":14,"rows_kept":42,"merged":[[0,12,0,13],[2,0,4,0],[2,1,4,1],[2,2,3,3],[2,4,3,5],[2,6,3,7],[2,8,3,9],[2,10,3,11],[2,12,3,13]]}
["НАПРАВЛЕНИЕ 2. МАТЕМАТИЧЕСКИЕ ПРЕДСТАВЛЕНИЯ",{"$nulls":11},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Определяет количественное соотношение двух групп предметов, понимает конкретный смысл слов «больше», «меньше», «столько же»",null,"Ориентируется в пространстве от себя: впереди (сзади), сверху (снизу), справа (слева)",null,"Знает и называет геметрические фигуры: шар, куб, круг, квадрат, треугольник",null,"Знает реальные явления и их изображения: утро-вечер, день-ночь, зима-лето",null,"Использует в речи слова, обохначающие свойства, качества предметов и отношений между ними",null,"среднее значение "]
[]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,{"$f":"(C6+E6+G6+I6+K6)/5","v":{"v":3.4,"d":"3.40"}},{"$f":"(D6+F6+H6+J6+L6)/5","v":{"v":4.4,"d":"4.40"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,{"$f":"(C7+E7+G7+I7+K7)/5","v":{"v":2.4,"d":"2.40"}},{"$f":"(D7+F7+H7+J7+L7)/5","v":{"v":3.4,"d":"3.40"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,"среднее значение:",{"$f":"(C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":3.25},{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.7,"d":"3.70"},3.85]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($M$6:$M$29,\">=3,8\")","v":12},{"$f":"COUNTIFS($M$6:$M$29,\"<3,7\",$M$6:$M$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($M$6:$M$29,\"<2,2\",$M$6:$M$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":50,"d":"50.0"}},{"$f":"E35*C36/C35","v":{"v":50,"d":"50.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($N$6:$N$29,\">=3,8\")","v":12},{"$f":"COUNTIFS($N$6:$N$29,\"<3,7\",$N$6:$N$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($N$6:$N$29,\"<2,2\",$N$6:$N$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D41*C42/C41","v":{"v":50,"d":"50.0"}},{"$f":"E41*C42/C41","v":{"v":50,"d":"50.0"}},{"$f":"F41*C42/C41","v":{"v":0,"d":"0.0"}}]

{"sheet":"ИТОГ ПР","index":10,"n_rows":37,"n_cols":6,"rows_kept":37,"merged":[[0,1,0,6],[1,1,1,6],[2,5,2,6],[28,0,28,1],[29,3,29,6],[30,3,30,6],[31,3,31,6],[32,3,32,6],[33,3,33,6],[34,3,34,6],[36,0,36,1],[36,3,36,6],[37,3,37,6],[38,3,38,6],[39,3,39,6],[40,3,40,6],[41,3,41,6],[42,3,42,6]]}
[null,"Обобщение результатов педагогической диагностики по направлениям"]
[null,"ОО «Познавательное развитие»"]
[{"$nulls":5},"ОГЛАВЛЕНИЕ"]
[null,null,"Сенсорные эталоны и познавательные действия. Окружающий мир. Природа.","Математические представления","Средний уровень"]
[null,null,"ФЦКМ","ФЭМП","ср.ур."]
[null,"начало",{"$f":"'ПР-1'!Y32","v":{"v":3.7045454545454546,"d":"3.70"}},{"$f":"'ПР-2'!M30","v":{"v":3.7,"d":"3.70"}},{"$f":"(C6+D6)/2","v":{"v":3.702272727272727,"d":"3.70"}}]
[null,"конец",{"$f":"'ПР-1'!Z32","v":{"v":3.9318181818181817,"d":"3.93"}},{"$f":"'ПР-2'!N30","v":3.85},{"$f":"(C7+D7)/2","v":{"v":3.8909090909090907,"d":"3.89"}}]
{"$rows_empty":20}
["ВЫВОДЫ:"]
["Начало учебного года:"]
{"$rows_empty":7}
["Конец учебного года:"]

{"sheet":"СК-1","index":11,"n_rows":45,"n_cols":23,"rows_kept":45,"merged":[[0,1,0,22],[2,21,2,22],[4,1,6,1],[4,2,6,2],[4,3,5,4],[4,5,5,6],[4,7,5,8],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[4,17,5,18],[4,19,5,20],[4,21,5,22]]}
[null,"Образовательная область «Социально-коммуникативное развитие»"]
[]
[null,"НАПРАВЛЕНИЕ 1,2. СОЦИАЛЬНЫЕ ОТНОШЕНИЯ. ФОРМИРОВАНИЕ ОСНОВ ГРАЖДАНСТВЕННОСТИ И ПАРТИОТИЗМА.",{"$nulls":19},"ОГЛАВЛЕНИЕ"]
[]
[null,"№п/п","ФИ ребенка","Проявляет устойчивый эмоциональный контакт с педработником и детьми",null,"Выполняет ролевые действия в игре. Соблюдает правила.",null,"Замечает несоответствие поведения других детей требованиям педработника",null,"Выражает интерес и проявляет внимание к различным эмоциональным состояниям человека",null,"Устанавливает положительные контакты между сверстниками",null,"Выполняет элементарные правила культуры поведения в ДОО",null,"Знает название населенного пункта, в котором живет",null,"Имеет представление о малой родине",null,"Может назвать некоторые достопримечательности родного города (поселка)",null,"среднее значение "]
[]
[{"$nulls":3},"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[null,1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"$f":"(D8+F8+H8+J8+L8+N8+P8+R8+T8)/9","v":{"v":3.2222222222222223,"d":"3.22"}},{"$f":"(E8+G8+I8+K8+M8+O8+Q8+S8+U8)/9","v":{"v":4.222222222222222,"d":"4.22"}}]
[null,2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,4,5,4,5,3,4,3,4,{"$f":"(D9+F9+H9+J9+L9+N9+P9+R9+T9)/9","v":{"v":2.888888888888889,"d":"2.89"}},{"$f":"(E9+G9+I9+K9+M9+O9+Q9+S9+U9)/9","v":{"v":3.888888888888889,"d":"3.89"}}]
[null,3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,3,4,3,4,3,{"v":3.7777777777777777,"d":"3.78"},{"v":2.6666666666666665,"d":"2.67"}]
[null,5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[null,6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[null,7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,3,4,3,4,3,{"v":3.7777777777777777,"d":"3.78"},{"v":2.6666666666666665,"d":"2.67"}]
[null,9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[null,10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[null,11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,3,4,3,4,3,{"v":3.7777777777777777,"d":"3.78"},{"v":2.6666666666666665,"d":"2.67"}]
[null,13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[null,14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[null,15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,3,4,3,4,3,{"v":3.7777777777777777,"d":"3.78"},{"v":2.6666666666666665,"d":"2.67"}]
[null,17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[null,18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[null,19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,3,4,3,4,3,{"v":3.7777777777777777,"d":"3.78"},{"v":2.6666666666666665,"d":"2.67"}]
[null,21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,{"v":3.2222222222222223,"d":"3.22"},{"v":4.222222222222222,"d":"4.22"}]
[null,22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.888888888888889,"d":"2.89"},{"v":3.888888888888889,"d":"3.89"}]
[null,23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,3,4,3,4,3,{"v":3.7777777777777777,"d":"3.78"},{"v":2.6666666666666665,"d":"2.67"}]
[null,null,"среднее значение:",{"$f":"(D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29+D30+D31)/(COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\"))","v":3.25},{"$f":"(E8+E9+E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31)/(COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"},3.75,4.25,3.75,{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"},{"v":3.7222222222222223,"d":"3.72"},{"v":3.9444444444444446,"d":"3.94"}]
[]
[]
[]
[null,null,"начало года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\")","v":24},{"$f":"COUNTIF(V8:V31,\">=3,8\")","v":6},{"$f":"COUNTIFS(V8:V31,\"<3,7\",V8:V31,\">=2,3\")","v":12},{"$f":"COUNTIFS(V8:V31,\"<2,2\",V8:V31,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E38*D39/D38","v":{"v":25,"d":"25.0"}},{"$f":"F38*D39/D38","v":{"v":50,"d":"50.0"}},{"$f":"G38*D39/D38","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,null,"конец года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\")","v":24},{"$f":"COUNTIF(W8:W31,\">=3,8\")","v":18},{"$f":"COUNTIFS(W8:W31,\"<3,7\",W8:W31,\">=2,3\")","v":6},{"$f":"COUNTIFS(W8:W31,\"<2,2\",W8:W31,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E44*D45/D44","v":{"v":75,"d":"75.0"}},{"$f":"F44*D45/D44","v":{"v":25,"d":"25.0"}},{"$f":"G44*D45/D44","v":{"v":0,"d":"0.0"}}]

{"sheet":"СК-2","index":12,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,1,0,14],[2,13,2,14],[4,1,6,1],[4,2,6,2],[4,3,5,4],[4,5,5,6],[4,7,5,8],[4,9,5,10],[4,11,5,12],[4,13,5,14]]}
[null,"Образовательная область «Социально-коммуникативное развитие»"]
[]
[null,"НАПРАВЛЕНИЕ 3. ТРУДОВОЕ ВОСПИТАНИЕ",{"$nulls":11},"ОГЛАВЛЕНИЕ"]
[]
[null,"№п/п","ФИ ребенка","Имеет представления о видах хозяйственно-бытового труда (мытье посуды, уборка помещений)",null,"Березно относится к предметам и игрушкам как результатам труда взрослых",null,"Умеет одеваться, раздеваться, умываться самостоятельно",null,"Убирает за собой игрушки",null,"Аккуратно складывает и убирает одежду",null,"среднее значение "]
[]
[{"$nulls":3},"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[null,1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,{"$f":"(D8+F8+H8+J8+L8)/5","v":{"v":3.4,"d":"3.40"}},{"$f":"(E8+G8+I8+K8+M8)/5","v":{"v":4.4,"d":"4.40"}}]
[null,2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,{"$f":"(D9+F9+H9+J9+L9)/5","v":{"v":2.4,"d":"2.40"}},{"$f":"(E9+G9+I9+K9+M9)/5","v":{"v":3.4,"d":"3.40"}}]
[null,3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[null,6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[null,7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[null,10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[null,11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[null,14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[null,15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[null,18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[null,19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[null,22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[null,23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,null,"среднее значение:",{"$f":"(D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29+D30+D31)/(COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\"))","v":3.25},{"v":3.5,"d":"3.50"},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.7,"d":"3.70"},3.85]
[]
[]
[]
[null,null,"начало года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\")","v":24},{"$f":"COUNTIF($N$8:$N$31,\">=3,8\")","v":12},{"$f":"COUNTIFS($N$8:$N$31,\"<3,7\",$N$8:$N$31,\">=2,3\")","v":12},{"$f":"COUNTIFS($N$8:$N$31,\"<2,2\",$N$8:$N$31,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E38*D39/D38","v":{"v":50,"d":"50.0"}},{"$f":"F38*D39/D38","v":{"v":50,"d":"50.0"}},{"$f":"G38*D39/D38","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,null,"конец года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$8:$C$31)-COUNTIF($C$8:$C$31,\"=0\")","v":24},{"$f":"COUNTIF($O$8:$O$31,\">=3,8\")","v":12},{"$f":"COUNTIFS($O$8:$O$31,\"<3,7\",$O$8:$O$31,\">=2,3\")","v":12},{"$f":"COUNTIFS($O$8:$O$31,\"<2,2\",$O$8:$O$31,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E44*D45/D44","v":{"v":50,"d":"50.0"}},{"$f":"F44*D45/D44","v":{"v":50,"d":"50.0"}},{"$f":"G44*D45/D44","v":{"v":0,"d":"0.0"}}]

{"sheet":"СК-3","index":13,"n_rows":42,"n_cols":16,"rows_kept":42,"merged":[[0,14,0,15],[2,0,4,0],[2,1,4,1],[2,2,3,3],[2,4,2,9],[2,10,3,11],[2,12,3,13],[2,14,3,15],[3,4,3,5],[3,6,3,7],[3,8,3,9]]}
["НАПРАВЛЕНИЕ 4. ФОРМИРОВАНИЕ БЕЗОПАСНОГО ПОВЕДЕНИЯ",{"$nulls":13},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Проявляет интерес к правилам безопасного поведения в быту",null,"Знает правила безопасного поведения и стремится их выполнять",{"$nulls":5},"Знает почему нельзя пользования самостоятельно бытовыми приборами (ножи, иголки, ножницы, лекартсва, спички)",null,"Знает и соблюдает правила дорожного движения и поведения на улице",null,"среднее значение "]
[{"$nulls":4},"в группе",null,"в общественных местах",null,"в природе"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,{"$f":"(C6+E6+G6+I6+K6+M6)/6","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"(D6+F6+H6+J6+L6+N6)/6","v":{"v":4.333333333333333,"d":"4.33"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,{"$f":"(C7+E7+G7+I7+K7+M7)/6","v":{"v":2.5,"d":"2.50"}},{"$f":"(D7+F7+H7+J7+L7+N7)/6","v":{"v":3.5,"d":"3.50"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,{"v":3.8333333333333335,"d":"3.83"},{"v":2.5,"d":"2.50"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,{"v":3.3333333333333335,"d":"3.33"},{"v":4.333333333333333,"d":"4.33"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,{"v":2.5,"d":"2.50"},{"v":3.5,"d":"3.50"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,{"v":3.8333333333333335,"d":"3.83"},{"v":2.5,"d":"2.50"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,{"v":3.3333333333333335,"d":"3.33"},{"v":4.333333333333333,"d":"4.33"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,{"v":2.5,"d":"2.50"},{"v":3.5,"d":"3.50"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,{"v":3.8333333333333335,"d":"3.83"},{"v":2.5,"d":"2.50"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,{"v":3.3333333333333335,"d":"3.33"},{"v":4.333333333333333,"d":"4.33"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,{"v":2.5,"d":"2.50"},{"v":3.5,"d":"3.50"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,{"v":3.8333333333333335,"d":"3.83"},{"v":2.5,"d":"2.50"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,{"v":3.3333333333333335,"d":"3.33"},{"v":4.333333333333333,"d":"4.33"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,{"v":2.5,"d":"2.50"},{"v":3.5,"d":"3.50"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,{"v":3.8333333333333335,"d":"3.83"},{"v":2.5,"d":"2.50"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,{"v":3.3333333333333335,"d":"3.33"},{"v":4.333333333333333,"d":"4.33"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,{"v":2.5,"d":"2.50"},{"v":3.5,"d":"3.50"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,{"v":3.8333333333333335,"d":"3.83"},{"v":2.5,"d":"2.50"}]
[null,"среднее значение:",{"$f":"(C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":3.25},{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,{"v":3.6666666666666665,"d":"3.67"},{"v":3.8333333333333335,"d":"3.83"}]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA(B6:B29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($O$6:$O$29,\">=3,8\")","v":12},{"$f":"COUNTIFS($O$6:$O$29,\"<3,7\",$O$6:$O$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($O$6:$O$29,\"<2,2\",$O$6:$O$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":50,"d":"50.0"}},{"$f":"E35*C36/C35","v":{"v":50,"d":"50.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA(B6:B29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($P$6:$P$29,\">=3,8\")","v":12},{"$f":"COUNTIFS($P$6:$P$29,\"<3,7\",$P$6:$P$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($P$6:$P$29,\"<2,2\",$P$6:$P$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D41*C42/C41","v":{"v":50,"d":"50.0"}},{"$f":"E41*C42/C41","v":{"v":50,"d":"50.0"}},{"$f":"F41*C42/C41","v":{"v":0,"d":"0.0"}}]

{"sheet":"ИТОГ СК","index":14,"n_rows":38,"n_cols":7,"rows_kept":38,"merged":[[0,1,0,6],[1,1,1,6],[2,6,2,7],[28,0,28,1],[29,0,29,1],[29,4,29,7],[30,4,30,7],[31,4,31,7],[32,4,32,7],[33,4,33,7],[34,4,34,7],[35,4,35,7],[37,0,37,1],[37,4,37,7],[38,4,38,7],[39,4,39,7],[40,4,40,7],[41,4,41,7],[42,4,42,7],[43,4,43,7]]}
[null,"Обобщение результатов педагогической диагностики по направлениям "]
[null,"ОО «Социально-коммуникативное развитие»"]
[{"$nulls":6},"ОГЛАВЛЕНИЕ"]
[null,null,"Социальные отношения. Формирование основ гражданственности и патриотизма","Трудовое воспитание","Формирование безопасного поведения","Средний балл/уровень (итоговый)"]
[null,null,1,2,3,"ср.ур."]
[null,"начало",{"$f":"'СК-1'!V32","v":{"v":3.7222222222222223,"d":"3.72"}},{"$f":"'СК-2'!N32","v":{"v":3.7,"d":"3.70"}},{"$f":"'СК-3'!O30","v":{"v":3.6666666666666665,"d":"3.67"}},{"$f":"(C6+D6+E6)/3","v":{"v":3.696296296296296,"d":"3.70"}}]
[null,"конец",{"$f":"'СК-1'!W32","v":{"v":3.9444444444444446,"d":"3.94"}},{"$f":"'СК-2'!O32","v":3.85},{"$f":"'СК-3'!P30","v":{"v":3.8333333333333335,"d":"3.83"}},{"$f":"(C7+D7+E7)/3","v":{"v":3.875925925925926,"d":"3.88"}}]
{"$rows_empty":21}
["ВЫВОДЫ:"]
["Начало уч.года:"]
{"$rows_empty":7}
["Конец уч.года:"]

{"sheet":"ХЭ-1","index":15,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,11],[1,8,1,9],[3,0,6,0],[3,1,6,1],[3,2,5,3],[3,4,5,5],[3,6,5,7],[3,8,5,9],[3,10,5,11]]}
["Образовательная область «Художественно-эстетическое развитие»"]
["НАПРАВЛЕНИЕ I. ПРИОБЩЕНИЕ К ИСКУССТВУ",{"$nulls":7},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Проявляет интерес к произведениям искусства",null,"Различает некоторые виды искусства",null,"Слушает чтение художественных текстов, сосредотачивается на этой деятельности на 10—15 минут, не отвлекаясь",null,"Проявляет положительный эмоциональный отклик на красоту природы",null,"среднее значение "]
[]
[]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,{"$f":"(C8+E8+G8+I8)/4","v":3.25},{"$f":"(D8+F8+H8+J8)/4","v":4.25}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,{"$f":"(C9+E9+G9+I9)/4","v":2.25},{"$f":"(D9+F9+H9+J9)/4","v":3.25}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,{"v":4,"d":"4.00"},2.75]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,3.25,4.25]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,2.25,3.25]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,{"v":4,"d":"4.00"},2.75]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,3.25,4.25]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,2.25,3.25]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,{"v":4,"d":"4.00"},2.75]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,3.25,4.25]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,2.25,3.25]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,{"v":4,"d":"4.00"},2.75]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,3.25,4.25]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,2.25,3.25]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,{"v":4,"d":"4.00"},2.75]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,3.25,4.25]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,2.25,3.25]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,{"v":4,"d":"4.00"},2.75]
[null,"среднее значение:",{"$f":"(C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29+C30+C31)/(COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\"))","v":3.25},{"$f":"(D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29+D30+D31)/(COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":3.625,"d":"3.63"},{"v":3.8125,"d":"3.81"}]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\")","v":24},{"$f":"COUNTIF($K$8:$K$31,\">=3,8\")","v":12},{"$f":"COUNTIFS($K$8:$K$31,\"<3,7\",$K$8:$K$31,\">=2,3\")","v":6},{"$f":"COUNTIFS($K$8:$K$31,\"<2,2\",$K$8:$K$31,\">0\")","v":0}]
[null,"%",100,{"$f":"D36*C37/C36","v":{"v":50,"d":"50.0"}},{"$f":"E36*C37/C36","v":{"v":25,"d":"25.0"}},{"$f":"F36*C37/C36","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\")","v":24},{"$f":"COUNTIF($L$8:$L$31,\">=3,8\")","v":12},{"$f":"COUNTIFS($L$8:$L$31,\"<3,7\",$L$8:$L$31,\">=2,3\")","v":12},{"$f":"COUNTIFS($L$8:$L$31,\"<2,2\",$L$8:$L$31,\">0\")","v":0}]
[null,"%",100,{"$f":"D42*C43/C42","v":{"v":50,"d":"50.0"}},{"$f":"E42*C43/C42","v":{"v":50,"d":"50.0"}},{"$f":"F42*C43/C42","v":{"v":0,"d":"0.0"}}]

{"sheet":"ХЭ-2","index":16,"n_rows":41,"n_cols":14,"rows_kept":41,"merged":[[0,12,0,13],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["НАПРАВЛЕНИЕ 2. КОНСТРУКТИВНАЯ ДЕЯТЕЛЬНОСТЬ",{"$nulls":11},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Знает, называет и правильно использует детали строительного материала. Изменяет постройки, надстраивая или заменяя одни детали другими",null,"Сооружает постройки по собственному замыслу",null,"Обыгрывает постройки, объединяя их по сюжету",null,"Знает свойства песна, снега при сооружении построек",null,"После игры аккуратно складывает детали в коробки",null,"среднее значение"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,{"$f":"(C5+E5+G5+I5+K5)/5","v":{"v":3.4,"d":"3.40"}},{"$f":"(D5+F5+H5+J5+L5)/5","v":{"v":4.4,"d":"4.40"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,{"$f":"(C6+E6+G6+I6+K6)/5","v":{"v":2.4,"d":"2.40"}},{"v":3.4,"d":"3.40"}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,{"v":3.4,"d":"3.40"},{"v":4.4,"d":"4.40"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,{"v":2.4,"d":"2.40"},{"v":3.4,"d":"3.40"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,{"v":4,"d":"4.00"},{"v":2.6,"d":"2.60"}]
[null,"среднее значение:",{"$f":"(C5+C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28)/(COUNTA($B$5:$B$28)-COUNTIF($B$5:$B$28,\"=0\"))","v":3.25},{"$f":"(D5+D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28)/(COUNTA($B$5:$B$28)-COUNTIF($B$5:$B$28,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"$f":"(C29+E29+G29+I29+K29)/5","v":{"v":3.7,"d":"3.70"}},{"$f":"(D29+F29+H29+J29+L29)/5","v":3.85}]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$5:$B$28)-COUNTIF($B$5:$B$28,\"=0\")","v":24},{"$f":"COUNTIF($M$5:$M$28,\">=3,8\")","v":12},{"$f":"COUNTIFS($M$5:$M$28,\"<3,7\",$M$5:$M$28,\">=2,3\")","v":12},{"$f":"COUNTIFS($M$5:$M$28,\"<2,2\",$M$5:$M$28,\">0\")","v":0}]
[null,"%",100,{"$f":"D34*C35/C34","v":{"v":50,"d":"50.0"}},{"$f":"E34*C35/C34","v":{"v":50,"d":"50.0"}},{"$f":"F34*C35/C34","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$5:$B$28)-COUNTIF($B$5:$B$28,\"=0\")","v":24},{"$f":"COUNTIF($N$5:$N$28,\">=3,8\")","v":12},{"$f":"COUNTIFS($N$5:$N$28,\"<3,7\",$N$5:$N$28,\">=2,3\")","v":12},{"$f":"COUNTIFS($N$5:$N$28,\"<2,2\",$N$5:$N$28,\">0\")","v":0}]
[null,"%",100,{"$f":"D40*C41/C40","v":{"v":50,"d":"50.0"}},{"$f":"E40*C41/C40","v":{"v":50,"d":"50.0"}},{"$f":"F40*C41/C40","v":{"v":0,"d":"0.0"}}]

{"sheet":"ХЭ-3","index":17,"n_rows":42,"n_cols":20,"rows_kept":42,"merged":[[0,18,0,19],[2,0,4,0],[2,1,4,1],[2,2,2,7],[2,8,2,11],[2,12,2,17],[2,18,3,19],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17]]}
["НАПРАВЛЕНИЕ 3. ИЗОБРАЗИТЕЛЬНАЯ ДЕЯТЕЛЬНОСТЬ",{"$nulls":17},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","рисование",{"$nulls":5},"лепка",{"$nulls":3},"аппликация; народное ДПИ",{"$nulls":5},"среднее значение "]
[null,null,"Правильно держит карандаш, не сжимая сильно пальцы",null,"рисует линии вразных направлениях",null,"создает несложные сюжетные композации",null,"раскатывает комочки прямыми и круговыми движениями",null,"создает предметы состоящие из 2-3 частей",null,"умеет пользоваться клеем",null,"Изображает/создаёт отдельные предметы, простые по композиции и по содержанию сюжеты, используя разные материалы",null,"Создаёт изображения предметов из готовых фигур. Украшает заготовки из бумаги разной формы"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"$f":"(C6+E6+G6+I6+K6+M6+O6+Q6)/8","v":3.25},{"$f":"(D6+F6+H6+J6+L6+N6+P6+R6)/8","v":4.25}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"$f":"(C7+E7+G7+I7+K7+M7+O7+Q7)/8","v":{"v":2.875,"d":"2.88"}},{"$f":"(D7+F7+H7+J7+L7+N7+P7+R7)/8","v":{"v":3.875,"d":"3.88"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.63"},{"v":2.5,"d":"2.50"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3.25,4.25]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.88"},{"v":3.875,"d":"3.88"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.63"},{"v":2.5,"d":"2.50"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3.25,4.25]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.88"},{"v":3.875,"d":"3.88"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.63"},{"v":2.5,"d":"2.50"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3.25,4.25]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.88"},{"v":3.875,"d":"3.88"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.63"},{"v":2.5,"d":"2.50"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3.25,4.25]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.88"},{"v":3.875,"d":"3.88"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.63"},{"v":2.5,"d":"2.50"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3.25,4.25]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.88"},{"v":3.875,"d":"3.88"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.63"},{"v":2.5,"d":"2.50"}]
[null,"среднее значение:",{"$f":"(C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":3.25},{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},3.75,4.25,{"v":3.6875,"d":"3.69"},{"v":3.90625,"d":"3.91"}]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($S$6:$S$29,\">=3,8\")","v":6},{"$f":"COUNTIFS($S$6:$S$29,\"<3,7\",$S$6:$S$29,\">=2,3\")","v":18},{"$f":"COUNTIFS($S$6:$S$29,\"<2,2\",$S$6:$S$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":25,"d":"25.0"}},{"$f":"E35*C36/C35","v":{"v":75,"d":"75.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($T$6:$T$29,\">=3,8\")","v":18},{"$f":"COUNTIFS($T$6:$T$29,\"<3,7\",$T$6:$T$29,\">=2,3\")","v":6},{"$f":"COUNTIFS($T$6:$T$29,\"<2,2\",$T$6:$T$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D41*C42/C41","v":{"v":75,"d":"75.0"}},{"$f":"E41*C42/C41","v":{"v":25,"d":"25.0"}},{"$f":"F41*C42/C41","v":{"v":0,"d":"0.0"}}]

{"sheet":"ХЭ-4","index":18,"n_rows":42,"n_cols":25,"rows_kept":42,"merged":[[0,23,0,24],[2,1,4,1],[2,2,4,2],[2,3,2,8],[2,9,2,12],[2,13,2,14],[2,15,2,18],[2,19,2,22],[2,23,3,24],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20],[3,21,3,22]]}
[null,"НАПРАВЛЕНИЕ 4. МУЗЫКАЛЬНАЯ ДЕЯТЕЛЬНОСТЬ",{"$nulls":21},"ОГЛАВЛЕНИЕ"]
[]
[null,"№п/п","ФИ ребенка","Слушание",{"$nulls":5},"Пение",{"$nulls":3},"Песенное творчество",null,"Музыкально-ритмические движения",{"$nulls":3},"Игра на ДМИ",{"$nulls":3},"среднее значение "]
[{"$nulls":3},"Слушает музыкальное произведение до конца, понимает характер музыки",null,"Различает звуки по высоте в пределах октавы - септимы, замечает изменения в силе звучания мелодии (громко, тихо)",null,"Различает звучание муз.игрушек, ДМИ",null,"Поет без напряжения в диапазоне ре(ми) - ля(си) в одном темпе со всеми",null,"Передает характер музыки (весело, протяжно, ласково, напевно)",null,"Допевает мелодии колыбельных песен на  слог \"баю-баю\" и веселых мелодий на слог \"ля-ля\"",null,"Умеет выполнять танцевальные движения: кружиться в парах, притоптывать попеременно ногами, двигаться под музыку с предметами",null,"Умеет передавать в движениях характер изображаемых животных",null,"Различает и называет музыкальные инструменты: дудочка, металлофон, колокольчик, бубен, погремушка, барабан,",null,"Старается подыгрывать на ДМИ"]
[{"$nulls":3},"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[null,1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,{"$f":"(D6+H6+F6+J6+L6+N6+P6+R6+T6+V6)/10","v":{"v":3.2,"d":"3.20"}},{"$f":"(E6+I6+G6+K6+M6+O6+Q6+S6+U6+W6)/10","v":{"v":4.2,"d":"4.20"}}]
[null,2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"$f":"(D7+H7+F7+J7+L7+N7+P7+R7+T7+V7)/10","v":{"v":2.9,"d":"2.90"}},{"$f":"(E7+I7+G7+K7+M7+O7+Q7+S7+U7+W7)/10","v":{"v":3.9,"d":"3.90"}}]
[null,3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,{"v":3.7,"d":"3.70"},{"v":2.6,"d":"2.60"}]
[null,5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,{"v":3.2,"d":"3.20"},{"v":4.2,"d":"4.20"}]
[null,6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.9,"d":"2.90"},{"v":3.9,"d":"3.90"}]
[null,7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,{"v":3.7,"d":"3.70"},{"v":2.6,"d":"2.60"}]
[null,9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,{"v":3.2,"d":"3.20"},{"v":4.2,"d":"4.20"}]
[null,10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.9,"d":"2.90"},{"v":3.9,"d":"3.90"}]
[null,11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,{"v":3.7,"d":"3.70"},{"v":2.6,"d":"2.60"}]
[null,13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,{"v":3.2,"d":"3.20"},{"v":4.2,"d":"4.20"}]
[null,14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.9,"d":"2.90"},{"v":3.9,"d":"3.90"}]
[null,15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,{"v":3.7,"d":"3.70"},{"v":2.6,"d":"2.60"}]
[null,17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,{"v":3.2,"d":"3.20"},{"v":4.2,"d":"4.20"}]
[null,18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.9,"d":"2.90"},{"v":3.9,"d":"3.90"}]
[null,19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,{"v":3.7,"d":"3.70"},{"v":2.6,"d":"2.60"}]
[null,21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,3,4,3,4,{"v":3.2,"d":"3.20"},{"v":4.2,"d":"4.20"}]
[null,22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,3,4,3,4,{"v":2.9,"d":"2.90"},{"v":3.9,"d":"3.90"}]
[null,23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[null,24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,4,3,4,3,{"v":3.7,"d":"3.70"},{"v":2.6,"d":"2.60"}]
[null,null,"среднее значение:",{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\"))","v":3.25},{"$f":"(E6+E7+E8+E9+E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29)/(COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\"))","v":{"v":3.5,"d":"3.50"}},{"v":3.5,"d":"3.50"},3.75,3.75,3.75,{"v":4,"d":"4.00"},4.25,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":4,"d":"4.00"},3.75,4.25,3.75,{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"},{"v":3.7,"d":"3.70"},{"v":3.925,"d":"3.93"}]
[]
[]
[null,null,"начало года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\")","v":24},{"$f":"COUNTIF($X$6:$X$29,\">=3,8\")","v":6},{"$f":"COUNTIFS($X$6:$X$29,\"<3,7\",$X$6:$X$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($X$6:$X$29,\"<2,2\",$X$6:$X$29,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E35*D36/D35","v":{"v":25,"d":"25.0"}},{"$f":"F35*D36/D35","v":{"v":50,"d":"50.0"}},{"$f":"G35*D36/D35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,null,"конец года"]
[{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,null,"количество детей",{"$f":"COUNTA($C$6:$C$29)-COUNTIF($C$6:$C$29,\"=0\")","v":24},{"$f":"COUNTIF($Y$6:$Y$29,\">=3,8\")","v":18},{"$f":"COUNTIFS($Y$6:$Y$29,\"<3,7\",$Y$6:$Y$29,\">=2,3\")","v":6},{"$f":"COUNTIFS($Y$6:$Y$29,\"<2,2\",$Y$6:$Y$29,\">0\")","v":0}]
[null,null,"%",100,{"$f":"E41*D42/D41","v":{"v":75,"d":"75.0"}},{"$f":"F41*D42/D41","v":{"v":25,"d":"25.0"}},{"$f":"G41*D42/D41","v":{"v":0,"d":"0.0"}}]

{"sheet":"ХЭ-5","index":19,"n_rows":42,"n_cols":15,"rows_kept":42,"merged":[[0,12,0,13],[2,0,4,0],[2,1,4,1],[2,2,2,5],[2,6,3,7],[2,8,2,11],[2,12,3,13],[3,2,3,3],[3,4,3,5],[3,8,3,9],[3,10,3,11],[32,8,32,10],[33,0,41,0],[33,7,41,7],[33,8,33,10],[34,8,34,10],[35,8,35,10],[38,8,38,10],[39,8,39,10],[40,8,40,10],[41,8,41,10]]}
["НАПРАВЛЕНИЕ 5. ТЕАТРАЛИЗОВАННАЯ И КУЛЬТУРНО-ДОСУГОВАЯ ДЕЯТЕЛЬНОСТЬ",{"$nulls":11},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Театрализованная деятельность",{"$nulls":3},"среднее значение",null,"Культурно-досуговая деятельность",{"$nulls":3},"среднее значение "]
[null,null,"Умеет передавать характеристики персонажей (ласковая кошечка, мишка косолапый)",null,"В играх-драматизациях следит за сюжетом",{"$nulls":3},"Проявляет интерес к различным видам досуговой деятельности",null,"С удовольствием участвует в праздниках, развлечениях и тд"]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},4,5,3,4,{"$f":"(C6+E6)/2","v":{"v":3.5,"d":"3.50"}},{"$f":"(D6+F6)/2","v":{"v":4.5,"d":"4.50"}},3,4,3,4,{"$f":"(I6+K6)/2","v":{"v":3,"d":"3.00"}},{"$f":"(J6+L6)/2","v":{"v":4,"d":"4.00"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},3,4,3,4,{"$f":"(C7+E7)/2","v":{"v":3,"d":"3.00"}},{"$f":"(D7+F7)/2","v":{"v":4,"d":"4.00"}},3,4,3,4,{"$f":"(I7+K7)/2","v":{"v":3,"d":"3.00"}},{"$f":"(J7+L7)/2","v":{"v":4,"d":"4.00"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},4,2,3,2,{"v":3.5,"d":"3.50"},{"v":2,"d":"2.00"},4,3,4,3,{"v":4,"d":"4.00"},{"v":3,"d":"3.00"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},4,5,3,4,{"v":3.5,"d":"3.50"},{"v":4.5,"d":"4.50"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},4,2,3,2,{"v":3.5,"d":"3.50"},{"v":2,"d":"2.00"},4,3,4,3,{"v":4,"d":"4.00"},{"v":3,"d":"3.00"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},4,5,3,4,{"v":3.5,"d":"3.50"},{"v":4.5,"d":"4.50"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},4,2,3,2,{"v":3.5,"d":"3.50"},{"v":2,"d":"2.00"},4,3,4,3,{"v":4,"d":"4.00"},{"v":3,"d":"3.00"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},4,5,3,4,{"v":3.5,"d":"3.50"},{"v":4.5,"d":"4.50"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},4,2,3,2,{"v":3.5,"d":"3.50"},{"v":2,"d":"2.00"},4,3,4,3,{"v":4,"d":"4.00"},{"v":3,"d":"3.00"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},4,5,3,4,{"v":3.5,"d":"3.50"},{"v":4.5,"d":"4.50"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},4,2,3,2,{"v":3.5,"d":"3.50"},{"v":2,"d":"2.00"},4,3,4,3,{"v":4,"d":"4.00"},{"v":3,"d":"3.00"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},4,5,3,4,{"v":3.5,"d":"3.50"},{"v":4.5,"d":"4.50"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},3,4,3,4,{"v":3,"d":"3.00"},{"v":4,"d":"4.00"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},5,5,5,5,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},4,2,3,2,{"v":3.5,"d":"3.50"},{"v":2,"d":"2.00"},4,3,4,3,{"v":4,"d":"4.00"},{"v":3,"d":"3.00"}]
[null,"среднее значение:",{"$f":"(C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":4,"d":"4.00"}},{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":4,"d":"4.00"}},{"v":3.5,"d":"3.50"},3.75,3.75,{"v":3.875,"d":"3.88"},{"$f":"(I6+I7+I8+I9+I10+I11+I12+I13+I14+I15+I16+I17+I18+I19+I20+I21+I22+I23+I24+I25+I26+I27+I28+I29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":3.75},{"$f":"(J6+J7+J8+J9+J10+J11+J12+J13+J14+J15+J16+J17+J18+J19+J20+J21+J22+J23+J24+J25+J26+J27+J28+J29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":4,"d":"4.00"}},{"$f":"(K6+K7+K8+K9+K10+K11+K12+K13+K14+K15+K16+K17+K18+K19+K20+K21+K22+K23+K24+K25+K26+K27+K28+K29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":3.75},{"v":4,"d":"4.00"},3.75,{"v":4,"d":"4.00"}]
[]
[]
[null,"начало года",{"$nulls":6},"начало года"]
["ТЕАТРАЛИЗОВАННАЯ ДЕЯТЕЛЬНОСТЬ",null,"всего","норма","ниже нормы","низкий ",null,"КУЛЬТУРНО-ДОСУГОВАЯ ДЕЯТЕЛЬНОСТЬ",{"$nulls":3},"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($G$6:$G$29,\">=3,8\")","v":6},{"$f":"COUNTIFS($G$6:$G$29,\"<3,7\",$G$6:$G$29,\">=2,3\")","v":18},{"$f":"COUNTIFS($G$6:$G$29,\"<2,2\",$G$6:$G$29,\">0\")","v":0},null,null,"количество детей",null,null,{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($M$6:$M$29,\">=3,8\")","v":12},{"$f":"COUNTIFS($M$6:$M$29,\"<3,7\",$M$6:$M$29,\">=2,3\")","v":12},{"$f":"COUNTIFS($M$6:$M$29,\"<2,2\",$M$6:$M$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D35*C36/C35","v":{"v":25,"d":"25.0"}},{"$f":"E35*C36/C35","v":{"v":75,"d":"75.0"}},{"$f":"F35*C36/C35","v":{"v":0,"d":"0.0"}},null,null,"%",null,null,100,{"$f":"M35*L36/L35","v":{"v":50,"d":"50.0"}},{"$f":"N35*L36/L35","v":{"v":50,"d":"50.0"}},{"$f":"O35*L36/L35","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года",{"$nulls":6},"конец года"]
[null,null,"всего","норма","ниже нормы","низкий ",{"$nulls":5},"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($H$6:$H$29,\">=3,8\")","v":18},{"$f":"COUNTIFS($H$6:$H$29,\"<3,7\",$H$6:$H$29,\">=2,3\")","v":0},{"$f":"COUNTIFS($H$6:$H$29,\"<2,2\",$H$6:$H$29,\">0\")","v":6},null,null,"количество детей",null,null,{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($N$6:$N$29,\">=3,8\")","v":18},{"$f":"COUNTIFS($N$6:$N$29,\"<3,7\",$N$6:$N$29,\">=2,3\")","v":6},{"$f":"COUNTIFS($N$6:$N$29,\"<2,2\",$N$6:$N$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D41*C42/C41","v":{"v":75,"d":"75.0"}},{"$f":"E41*C42/C41","v":{"v":0,"d":"0.0"}},{"$f":"F41*C42/C41","v":{"v":25,"d":"25.0"}},null,null,"%",null,null,100,{"$f":"M41*L42/L41","v":{"v":75,"d":"75.0"}},{"$f":"N41*L42/L41","v":{"v":25,"d":"25.0"}},{"$f":"O41*L42/L41","v":{"v":0,"d":"0.0"}}]

{"sheet":"ИТОГ ХЭ","index":20,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[0,0,0,7],[1,0,1,7],[28,0,28,1],[28,2,28,7],[29,2,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[36,0,36,1],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7],[40,2,40,7],[41,2,41,7],[42,2,42,7]]}
["Обобщение результатов педагогической диагностики по направлениям"]
["ОО «Художественно-эстетическое развитие»"]
[{"$nulls":7},"ОГЛАВЛЕНИЕ"]
[null,"Приобщение к искусству","Конструктивная деятельность","Изобразительная деятельность","Музыкальная деятельность","Театрализованная деятельность","Культурно-досуговая деятельность","Средний балл/уровень "]
[null,1,2,3,4,5,6,"ср.ур."]
["начало",{"$f":"'ХЭ-1'!K32","v":{"v":3.625,"d":"3.63"}},{"$f":"'ХЭ-2'!M29","v":{"v":3.7,"d":"3.70"}},{"$f":"'ХЭ-3'!S30","v":{"v":3.6875,"d":"3.69"}},{"$f":"'ХЭ-4'!X30","v":{"v":3.7,"d":"3.70"}},{"$f":"'ХЭ-5'!G30","v":3.75},{"$f":"'ХЭ-5'!M30","v":3.75},{"$f":"(B6+C6+D6+E6+F6+G6)/6","v":{"v":3.702083333333333,"d":"3.70"}}]
["конец",{"$f":"'ХЭ-1'!L32","v":{"v":3.8125,"d":"3.81"}},{"$f":"'ХЭ-2'!N29","v":3.85},{"$f":"'ХЭ-3'!T30","v":{"v":3.90625,"d":"3.91"}},{"$f":"'ХЭ-4'!Y30","v":{"v":3.925,"d":"3.93"}},{"$f":"'ХЭ-5'!H30","v":{"v":3.875,"d":"3.88"}},{"$f":"'ХЭ-5'!N30","v":{"v":4,"d":"4.00"}},{"$f":"(B7+C7+D7+E7+F7+G7)/6","v":{"v":3.8947916666666664,"d":"3.89"}}]
{"$rows_empty":20}
["ВЫВОДЫ:"]
["Начало учебного года:"]
{"$rows_empty":7}
["Конец учебного года:"]

{"sheet":"ФР-1","index":21,"n_rows":45,"n_cols":20,"rows_kept":45,"merged":[[0,0,0,19],[4,0,6,0],[4,1,6,1],[4,2,5,3],[4,4,5,5],[4,6,5,7],[4,8,5,9],[4,10,5,11],[4,12,5,13],[4,14,5,15],[4,16,5,17],[4,18,5,19]]}
["Образовательная область «Физическое развитие»"]
[]
["НАПРАВЛЕНИЕ I. ОСНОВНАЯ ГИМНАСТИКА. ПОДВИЖНЫЕ И СПОРТИВНЫЕ ИГРЫ. СПОРТИВНЫЕ УПРАЖНЕНИЯ"]
[]
["№п/п","ФИ ребенка","Умеет ходить и бегать, сохраняя равновесие, в разных направлениях по указанию взрослого",null,"Прыгает на двух и на одной ноге; наместе, продвигаясь вперед",null,"Энергично отталкивается в прыжках на двух ногах, прыгает в длину с места",null,"Организованно выполняет строевые упражнеия, находит свое место при перестроении",null,"Выполняет упражнения по показу",null,"Выполняет задания сообща, действует в общем для всех темпе",null,"Катает мяч в заданном направлении с расстояния, бросает мяч двумя руками от груди, из-за головы; ударяет мячом об пол, бросает вверх и ловит; метает предметы правой и левой руками",null,"Соблюдает правила в подвижных играх",null,"среднее значение "]
[]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"$f":"(C8+E8+G8+I8+K8+M8+O8+Q8)/8","v":{"v":3.25,"d":"3.3"}},{"$f":"(D8+F8+H8+J8+L8+N8+P8+R8)/8","v":{"v":4.25,"d":"4.3"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"$f":"(C9+E9+G9+I9+K9+M9+O9+Q9)/8","v":{"v":2.875,"d":"2.9"}},{"$f":"(D9+F9+H9+J9+L9+N9+P9+R9)/8","v":{"v":3.875,"d":"3.9"}}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.6"},2.5]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.9"},{"v":3.875,"d":"3.9"}]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.6"},2.5]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.9"},{"v":3.875,"d":"3.9"}]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.6"},2.5]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.9"},{"v":3.875,"d":"3.9"}]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.6"},2.5]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.9"},{"v":3.875,"d":"3.9"}]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.6"},2.5]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},3,4,3,4,3,4,4,5,4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},2,3,2,3,2,3,3,4,3,4,3,4,4,5,4,5,{"v":2.875,"d":"2.9"},{"v":3.875,"d":"3.9"}]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},3,2,4,3,5,3,4,3,4,2,3,2,3,2,3,3,{"v":3.625,"d":"3.6"},2.5]
[null,"среднее значение:",{"$f":"(C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29+C30+C31)/(COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\"))","v":{"v":3.25,"d":"3.3"}},{"$f":"(D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29+D30+D31)/(COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\"))","v":3.5},3.5,{"v":3.75,"d":"3.8"},{"v":3.75,"d":"3.8"},{"v":3.75,"d":"3.8"},{"v":4,"d":"4.0"},{"v":4.25,"d":"4.3"},{"v":4,"d":"4.0"},{"v":4,"d":"4.0"},3.5,{"v":3.75,"d":"3.8"},{"v":3.75,"d":"3.8"},{"v":4,"d":"4.0"},{"v":3.75,"d":"3.8"},{"v":4.25,"d":"4.3"},{"v":3.6875,"d":"3.7"},{"v":3.90625,"d":"3.9"}]
[]
[]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\")","v":24},{"$f":"COUNTIF($S$8:$S$31,\">=3,8\")","v":6},{"$f":"COUNTIFS($S$8:$S$31,\"<3,7\",$S$8:$S$31,\">=2,3\")","v":18},{"$f":"COUNTIFS($S$8:$S$31,\"<2,2\",$S$8:$S$31,\">0\")","v":0}]
[null,"%",100,{"$f":"D38*C39/C38","v":{"v":25,"d":"25.0"}},{"$f":"E38*C39/C38","v":{"v":75,"d":"75.0"}},{"$f":"F38*C39/C38","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$8:$B$31)-COUNTIF($B$8:$B$31,\"=0\")","v":24},{"$f":"COUNTIF($T$8:$T$31,\">=3,8\")","v":18},{"$f":"COUNTIFS($T$8:$T$31,\"<3,7\",$T$8:$T$31,\">=2,3\")","v":6},{"$f":"COUNTIFS($T$8:$T$31,\"<2,2\",$T$8:$T$31,\">0\")","v":0}]
[null,"%",100,{"$f":"D44*C45/C44","v":{"v":75,"d":"75.0"}},{"$f":"E44*C45/C44","v":{"v":25,"d":"25.0"}},{"$f":"F44*C45/C44","v":{"v":0,"d":"0.0"}}]

{"sheet":"ФР-2","index":22,"n_rows":40,"n_cols":12,"rows_kept":40,"merged":[[0,10,0,11],[2,0,4,0],[2,1,4,1],[2,2,3,3],[2,4,3,5],[2,6,3,7],[2,8,3,9],[2,10,3,11]]}
["НАПРАВЛЕНИЕ 2. ФОРМИРОВАНИЕ ОСНОВ ЗДОРОВОГО ОБРАЗА ЖИЗНИ. АКТИВНЫЙ ОТДЫХ",{"$nulls":9},"ОГЛАВЛЕНИЕ"]
[]
["№п/п","ФИ ребенка","Стремится самостоятельно ухаживать за собой, союлюдает порядок и чистоту, ухаживает за своими вещами и игрушками",null,"Соблюдает правила безопасности в двигательной деятельности",null,"Владеет простейшими навыками поведения во время еды, умывания",null,"Имеет представление о здоровом образе жизни (закаливание, питание, привычки, двигательный режим)",null,"среднее значение "]
[]
[null,null,"н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г.","н.г.","к.г."]
[1,{"$f":"'Список группы'!C4","v":"Бахтин Антон"},4,5,3,4,3,4,3,4,{"$f":"(C6+E6+G6+I6)/4","v":{"v":3.25,"d":"3.3"}},{"$f":"(D6+F6+H6+J6)/4","v":{"v":4.25,"d":"4.3"}}]
[2,{"$f":"'Список группы'!C5","v":"Башилова Наталья"},3,4,3,4,4,5,4,5,{"$f":"(C7+E7+G7+I7)/4","v":3.5},{"$f":"(D7+F7+H7+J7)/4","v":4.5}]
[3,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"},5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[4,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"},4,2,3,2,3,2,3,3,{"v":3.25,"d":"3.3"},{"v":2.25,"d":"2.3"}]
[5,{"$f":"'Список группы'!C8","v":"Гущина Софья"},4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[6,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"},3,4,3,4,4,5,4,5,3.5,4.5]
[7,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"},5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[8,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"},4,2,3,2,3,2,3,3,{"v":3.25,"d":"3.3"},{"v":2.25,"d":"2.3"}]
[9,{"$f":"'Список группы'!C12","v":"Князева Алиса"},4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[10,{"$f":"'Список группы'!C13","v":"Максимова Анна"},3,4,3,4,4,5,4,5,3.5,4.5]
[11,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"},5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[12,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"},4,2,3,2,3,2,3,3,{"v":3.25,"d":"3.3"},{"v":2.25,"d":"2.3"}]
[13,{"$f":"'Список группы'!C16","v":"Панов Тимофей "},4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[14,{"$f":"'Список группы'!C17","v":"Саркисов Илья "},3,4,3,4,4,5,4,5,3.5,4.5]
[15,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "},5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[16,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"},4,2,3,2,3,2,3,3,{"v":3.25,"d":"3.3"},{"v":2.25,"d":"2.3"}]
[17,{"$f":"'Список группы'!C20","v":"Сергеев Алексей"},4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[18,{"$f":"'Список группы'!C21","v":"Солопов Максим"},3,4,3,4,4,5,4,5,3.5,4.5]
[19,{"$f":"'Список группы'!C22","v":"Стригунов Александр "},5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[20,{"$f":"'Список группы'!C23","v":"Тихонов Данил"},4,2,3,2,3,2,3,3,{"v":3.25,"d":"3.3"},{"v":2.25,"d":"2.3"}]
[21,{"$f":"'Список группы'!C24","v":"Федоров Данила"},4,5,3,4,3,4,3,4,{"v":3.25,"d":"3.3"},{"v":4.25,"d":"4.3"}]
[22,{"$f":"'Список группы'!C25","v":"Чалдина Дарья"},3,4,3,4,4,5,4,5,3.5,4.5]
[23,{"$f":"'Список группы'!C26","v":"Черногоров Аркадий "},5,5,5,5,5,5,5,5,{"v":5,"d":"5.0"},{"v":5,"d":"5.0"}]
[24,{"$f":"'Список группы'!C27","v":"Шагабудинов Владислав "},4,2,3,2,3,2,3,3,{"v":3.25,"d":"3.3"},{"v":2.25,"d":"2.3"}]
[null,"среднее значение:",{"$f":"(C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":4,"d":"4.0"}},{"$f":"(D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29)/(COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\"))","v":{"v":4,"d":"4.0"}},3.5,{"v":3.75,"d":"3.8"},{"v":3.75,"d":"3.8"},{"v":4,"d":"4.0"},{"v":3.75,"d":"3.8"},{"v":4.25,"d":"4.3"},{"v":3.75,"d":"3.8"},{"v":4,"d":"4.0"}]
[]
[null,"начало года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($K$6:$K$29,\">=3,8\")","v":6},{"$f":"COUNTIFS($K$6:$K$29,\"<3,7\",$K$6:$K$29,\">=2,3\")","v":18},{"$f":"COUNTIFS($K$6:$K$29,\"<2,2\",$K$6:$K$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D34*C35/C34","v":{"v":25,"d":"25.0"}},{"$f":"E34*C35/C34","v":{"v":75,"d":"75.0"}},{"$f":"F34*C35/C34","v":{"v":0,"d":"0.0"}}]
[]
[null,"конец года"]
[null,null,"всего","норма","ниже нормы","низкий "]
[null,"количество детей",{"$f":"COUNTA($B$6:$B$29)-COUNTIF($B$6:$B$29,\"=0\")","v":24},{"$f":"COUNTIF($L$6:$L$29,\">=3,8\")","v":18},{"$f":"COUNTIFS($L$6:$L$29,\"<3,7\",$L$6:$L$29,\">=2,3\")","v":0},{"$f":"COUNTIFS($L$6:$L$29,\"<2,2\",$L$6:$L$29,\">0\")","v":0}]
[null,"%",100,{"$f":"D39*C40/C39","v":{"v":75,"d":"75.0"}},{"$f":"E39*C40/C39","v":{"v":0,"d":"0.0"}},{"$f":"F39*C40/C39","v":{"v":0,"d":"0.0"}}]

{"sheet":"ИТОГ ФР","index":23,"n_rows":38,"n_cols":5,"rows_kept":38,"merged":[[0,0,0,5],[1,0,1,5],[2,4,2,5],[28,0,28,1],[29,3,29,5],[30,3,30,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[35,3,35,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[42,3,42,5],[43,3,43,5]]}
["Обобщение результатов педагогической диагностики по направлениям"]
[" ОО «Физическое развитие»"]
[{"$nulls":4},"ОГЛАВЛЕНИЕ"]
[]
[null,null,"Основная гимнастика. Подвижные и спортивные игры. Спортивные упражнения.","Формирование основ здорового образа жизни. Активный отдых.","Средний балл/уровень"]
[null,null,1,2,"ср.ур."]
[null,"начало",{"$f":"'ФР-1'!$S$32","v":{"v":3.6875,"d":"3.69"}},{"$f":"'ФР-2'!K30","v":3.75},{"$f":"(C7+D7)/2","v":{"v":3.71875,"d":"3.72"}}]
[null,"конец",{"$f":"'ФР-1'!$T$32","v":{"v":3.90625,"d":"3.91"}},{"$f":"'ФР-2'!L30","v":{"v":4,"d":"4.00"}},{"$f":"(C8+D8)/2","v":{"v":3.953125,"d":"3.95"}}]
{"$rows_empty":20}
["ВЫВОДЫ:"]
["Начало учебного года:"]
{"$rows_empty":7}
["Конец учебного года:"]

{"sheet":"ОБЩИЙ ИТОГ","index":24,"n_rows":63,"n_cols":8,"rows_kept":63,"merged":[[0,1,0,7],[1,1,1,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[38,1,38,3],[38,4,38,7],[44,1,44,3],[44,4,44,7],[50,1,50,3],[50,4,50,7],[56,1,56,3],[56,4,56,7],[62,1,62,3],[62,4,62,7],[63,4,63,7],[64,4,64,7],[65,4,65,7],[66,4,66,7],[67,4,67,7]]}
[null,"Обобщение результатов педагогической диагностики по всем образовательным областям "]
[null," на 202__/2____ учебный год"]
[{"$nulls":7},"ОГЛАВЛЕНИЕ"]
[]
[null,null,"Речевое развитие","Познавательное развитие","Социально­коммуникативное развитие","Художественно­эстетическое развитие","Физическое развитие","Средний балл/уровень"]
[null,null,"РР","ПР","СК","ХЭ","ФР","ср.ур."]
[null,"начало",{"$f":"'ИТОГ РР'!F7","v":{"v":3.6947150072150072,"d":"3.69"}},{"$f":"'ИТОГ ПР'!E6","v":{"v":3.702272727272727,"d":"3.70"}},{"$f":"'ИТОГ СК'!F6","v":{"v":3.696296296296296,"d":"3.70"}},{"$f":"'ИТОГ ХЭ'!H6","v":{"v":3.702083333333333,"d":"3.70"}},{"$f":"'ИТОГ ФР'!E7","v":{"v":3.71875,"d":"3.72"}},{"$f":"(C7+D7+E7+F7+G7)/5","v":{"v":3.7028234728234724,"d":"3.70"}}]
[null,"конец",{"$f":"'ИТОГ РР'!F8","v":{"v":3.896374458874459,"d":"3.90"}},{"$f":"'ИТОГ ПР'!E7","v":{"v":3.8909090909090907,"d":"3.89"}},{"$f":"'ИТОГ СК'!F7","v":{"v":3.875925925925926,"d":"3.88"}},{"$f":"'ИТОГ ХЭ'!H7","v":{"v":3.8947916666666664,"d":"3.89"}},{"$f":"'ИТОГ ФР'!E8","v":{"v":3.953125,"d":"3.95"}},{"$f":"(C8+D8+E8+F8+G8)/5","v":{"v":3.9022252284752286,"d":"3.90"}}]
{"$rows_empty":20}
[null,"Основные выводы по результатам педагогической диагностики"]
[]
[null,"Педагогический процесс организован на _________ уровне."]
[null,"Следует обратить внимание на трудности реализации образовательной(-ых) области(-ей) «_________ развитие» в следующих аспектах:"]
[null,"1."]
[null,"2."]
[null,"3."]
[]
[]
[null,"В индивидуальной помощи нуждаются следующие дети:"]
[null,"1. «Речевое развитие»:"]
[]
[]
[]
[]
[]
[null,"2. «Познавательное развитие»:"]
[]
[]
[]
[]
[]
[null,"3. «Социально-коммуникативное развитие»: "]
[]
[]
[]
[]
[]
[null,"4. «Художественно-эстетическое развитие»:"]
[]
[]
[]
[]
[]
[null,"5. «Физическое развитие»: "]

{"sheet":"Инд.показатели","index":25,"n_rows":1111,"n_cols":8,"rows_kept":1111,"merged":[[0,3,0,5],[2,1,3,2],[4,1,4,2],[5,1,5,2],[8,1,8,5],[9,1,9,5],[25,1,25,7],[26,2,26,3],[26,4,26,7],[27,2,27,3],[27,4,27,7],[41,3,41,5],[43,1,43,2],[45,1,45,2],[46,1,46,2],[49,1,49,5],[50,1,50,5],[66,1,66,7],[67,2,67,3],[67,4,67,7],[68,2,68,3],[68,4,68,7],[88,1,88,2],[90,1,90,2],[91,1,91,2],[94,1,94,5],[95,1,95,5],[111,1,111,7],[112,2,112,3],[112,4,112,7],[113,2,113,3],[113,4,113,7],[131,3,131,5],[133,1,133,2],[135,1,135,2],[136,1,136,2],[139,1,139,5],[140,1,140,5],[156,1,156,7],[157,2,157,3],[157,4,157,7],[158,2,158,3],[158,4,158,7],[174,3,174,5],[176,1,176,2],[178,1,178,2],[179,1,179,2],[182,1,182,5],[183,1,183,5],[199,1,199,7],[200,2,200,3],[200,4,200,7],[201,2,201,3],[201,4,201,7],[220,3,220,5],[222,1,222,2],[224,1,224,2],[225,1,225,2],[228,1,228,5],[229,1,229,5],[245,1,245,7],[246,2,246,3],[246,4,246,7],[247,2,247,3],[247,4,247,7],[267,3,267,5],[269,1,269,2],[271,1,271,2],[272,1,272,2],[275,1,275,5],[276,1,276,5],[292,1,292,7],[293,2,293,3],[293,4,293,7],[294,2,294,3],[294,4,294,7],[315,3,315,5],[317,1,317,2],[319,1,319,2],[320,1,320,2],[323,1,323,5],[324,1,324,5],[340,1,340,7],[341,2,341,3],[341,4,341,7],[342,2,342,3],[342,4,342,7],[363,3,363,5],[365,1,365,2],[367,1,367,2],[368,1,368,2],[371,1,371,5],[372,1,372,5],[388,1,388,7],[389,2,389,3],[389,4,389,7],[390,2,390,3],[390,4,390,7],[411,3,411,5],[413,1,413,2],[415,1,415,2],[416,1,416,2],[419,1,419,5],[420,1,420,5],[436,1,436,7],[437,2,437,3],[437,4,437,7],[438,2,438,3],[438,4,438,7],[459,3,459,5],[461,1,461,2],[463,1,463,2],[464,1,464,2],[467,1,467,5],[468,1,468,5],[484,1,484,7],[485,2,485,3],[485,4,485,7],[486,2,486,3],[486,4,486,7],[507,3,507,5],[509,1,509,2],[511,1,511,2],[512,1,512,2],[515,1,515,5],[516,1,516,5],[532,1,532,7],[533,2,533,3],[533,4,533,7],[534,2,534,3],[534,4,534,7],[555,3,555,5],[557,1,557,2],[559,1,559,2],[560,1,560,2],[563,1,563,5],[564,1,564,5],[580,1,580,7],[581,2,581,3],[581,4,581,7],[582,2,582,3],[582,4,582,7],[603,3,603,5],[605,1,605,2],[607,1,607,2],[608,1,608,2],[611,1,611,5],[612,1,612,5],[628,1,628,7],[629,2,629,3],[629,4,629,7],[630,2,630,3],[630,4,630,7],[651,3,651,5],[653,1,653,2],[655,1,655,2],[656,1,656,2],[659,1,659,5],[660,1,660,5],[676,1,676,7],[677,2,677,3],[677,4,677,7],[678,2,678,3],[678,4,678,7],[699,3,699,5],[701,1,701,2],[703,1,703,2],[704,1,704,2],[707,1,707,5],[708,1,708,5],[724,1,724,7],[725,2,725,3],[725,4,725,7],[726,2,726,3],[726,4,726,7],[747,3,747,5],[749,1,749,2],[751,1,751,2],[752,1,752,2],[755,1,755,5],[756,1,756,5],[772,1,772,7],[773,2,773,3],[773,4,773,7],[774,2,774,3],[774,4,774,7],[795,3,795,5],[797,1,797,2],[799,1,799,2],[800,1,800,2],[803,1,803,5],[804,1,804,5],[820,1,820,7],[821,2,821,3],[821,4,821,7],[822,2,822,3],[822,4,822,7],[843,3,843,5],[845,1,845,2],[847,1,847,2],[848,1,848,2],[851,1,851,5],[852,1,852,5],[868,1,868,7],[869,2,869,3],[869,4,869,7],[870,2,870,3],[870,4,870,7],[891,3,891,5],[893,1,893,2],[895,1,895,2],[896,1,896,2],[899,1,899,5],[900,1,900,5],[916,1,916,7],[917,2,917,3],[917,4,917,7],[918,2,918,3],[918,4,918,7],[939,3,939,5],[941,1,941,2],[943,1,943,2],[944,1,944,2],[947,1,947,5],[948,1,948,5],[964,1,964,7],[965,2,965,3],[965,4,965,7],[966,2,966,3],[966,4,966,7],[987,3,987,5],[989,1,989,2],[991,1,991,2],[992,1,992,2],[995,1,995,5],[996,1,996,5],[1012,1,1012,7],[1013,2,1013,3],[1013,4,1013,7],[1014,2,1014,3],[1014,4,1014,7],[1035,3,1035,5],[1037,1,1037,2],[1039,1,1039,2],[1040,1,1040,2],[1043,1,1043,5],[1044,1,1044,5],[1060,1,1060,7],[1061,2,1061,3],[1061,4,1061,7],[1062,2,1062,3],[1062,4,1062,7],[1083,3,1083,5],[1085,1,1085,2],[1087,1,1087,2],[1088,1,1088,2],[1091,1,1091,5],[1092,1,1092,5],[1108,1,1108,7],[1109,2,1109,3],[1109,4,1109,7],[1110,2,1110,3],[1110,4,1110,7]]}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C4","v":"Бахтин Антон"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$7+'РР-2'!$Q$6+'РР-3'!$Y$6+'РР-4'!$R$6)/4","v":{"v":3.2438672438672436,"d":"3.2"}},{"$f":"('ПР-1'!$Y$8+'ПР-2'!$M$6)/2","v":{"v":3.290909090909091,"d":"3.3"}},{"$f":"('СК-1'!$V$8+'СК-2'!$N$8+'СК-3'!$O$6)/3","v":{"v":3.3185185185185184,"d":"3.3"}},{"$f":"('ХЭ-1'!$K$8+'ХЭ-2'!$M$5+'ХЭ-3'!$S$6+'ХЭ-4'!$X$6+'ХЭ-5'!$G$6+'ХЭ-5'!$M$6)/6","v":{"v":3.266666666666667,"d":"3.3"}},{"$f":"('ФР-1'!$S$8+'ФР-2'!$K$6)/2","v":{"v":3.25,"d":"3.3"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$7+'РР-2'!$R$6+'РР-3'!$Z$6+'РР-4'!$S$6)/4","v":{"v":4.243867243867244,"d":"4.2"}},{"$f":"('ПР-1'!$Z$8+'ПР-2'!$N$6)/2","v":{"v":4.290909090909091,"d":"4.3"}},{"$f":"('СК-1'!$W$8+'СК-2'!$O$8+'СК-3'!$P$6)/3","v":{"v":4.318518518518519,"d":"4.3"}},{"$f":"('ХЭ-1'!$L$8+'ХЭ-2'!$N$5+'ХЭ-3'!$T$6+'ХЭ-4'!$Y$6+'ХЭ-5'!$H$6+'ХЭ-5'!$N$6)/6","v":{"v":4.266666666666667,"d":"4.3"}},{"$f":"('ФР-1'!$T$8+'ФР-2'!$L$6)/2","v":{"v":4.25,"d":"4.3"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D5:H5)","v":{"v":16.36996151996152,"d":"16"}},{"$f":"SUM(D6:H6)","v":{"v":21.36996151996152,"d":"21"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"$G$9/25","v":{"v":0.6547984607984608,"d":"65%"}},{"$f":"$H$9/25","v":{"v":0.8547984607984609,"d":"85%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G10","v":{"v":0.6547984607984608,"d":"65%"}},null,{"$f":"IF(C27>=80%,\"Высокий уровень\",IF(C27>=50%,\"Средний уровень\",IF(C27<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H10","v":{"v":0.8547984607984609,"d":"85%"}},null,{"$f":"IF(C28>=80%,\"Высокий уровень\",IF(C28>=50%,\"Средний уровень\",IF(C28<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":13}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C5","v":"Башилова Наталья"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$8+'РР-2'!$Q$7+'РР-3'!$Y$7+'РР-4'!$R$7)/4","v":{"v":2.829365079365079,"d":"2.8"}},{"$f":"('ПР-1'!$Y$9+'ПР-2'!$M$7)/2","v":{"v":2.6545454545454543,"d":"2.7"}},{"$f":"('СК-1'!$V$9+'СК-2'!$N$9+'СК-3'!$O$7)/3","v":{"v":2.596296296296296,"d":"2.6"}},{"$f":"('ХЭ-1'!$K$9+'ХЭ-2'!$M$6+'ХЭ-3'!$S$7+'ХЭ-4'!$X$7+'ХЭ-5'!$G$7+'ХЭ-5'!$M$7)/6","v":{"v":2.7375000000000003,"d":"2.7"}},{"$f":"('ФР-1'!$S$9+'ФР-2'!$K$7)/2","v":{"v":3.1875,"d":"3.2"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$8+'РР-2'!$R$7+'РР-3'!$Z$7+'РР-4'!$S$7)/4","v":{"v":3.829365079365079,"d":"3.8"}},{"$f":"('ПР-1'!$Z$9+'ПР-2'!$N$7)/2","v":{"v":3.6545454545454543,"d":"3.7"}},{"$f":"('СК-1'!$W$9+'СК-2'!$O$9+'СК-3'!$P$7)/3","v":{"v":3.596296296296296,"d":"3.6"}},{"$f":"('ХЭ-1'!$L$9+'ХЭ-2'!$N$6+'ХЭ-3'!$T$7+'ХЭ-4'!$Y$7+'ХЭ-5'!$H$7+'ХЭ-5'!$N$7)/6","v":{"v":3.7375000000000003,"d":"3.7"}},{"$f":"('ФР-1'!$T$9+'ФР-2'!$L$7)/2","v":{"v":4.1875,"d":"4.2"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D46:H46)","v":{"v":14.00520683020683,"d":"14"}},{"$f":"SUM(D47:H47)","v":{"v":19.00520683020683,"d":"19"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G50/25","v":{"v":0.5602082732082733,"d":"56%"}},{"$f":"H50/25","v":{"v":0.7602082732082732,"d":"76%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G51","v":{"v":0.5602082732082733,"d":"56%"}},null,{"$f":"IF(C68>=80%,\"Высокий уровень\",IF(C68>=50%,\"Средний уровень\",IF(C68<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H51","v":{"v":0.7602082732082732,"d":"76%"}},null,{"$f":"IF(C69>=80%,\"Высокий уровень\",IF(C69>=50%,\"Средний уровень\",IF(C69<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":17}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C6","v":"Бирюкова Екатерина"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$9+'РР-2'!$Q$8+'РР-3'!$Y$8+'РР-4'!$R$8)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Y$10+'ПР-2'!$M$8)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$V$10+'СК-2'!$N$10+'СК-3'!$O$8)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$K$10+'ХЭ-2'!$M$7+'ХЭ-3'!$S$8+'ХЭ-4'!$X$8+'ХЭ-5'!$G$8+'ХЭ-5'!$M$8)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$10+'ФР-2'!$K$8)/2","v":{"v":5,"d":"5.0"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$9+'РР-2'!$R$8+'РР-3'!$Z$8+'РР-4'!$S$8)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Z$10+'ПР-2'!$N$8)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$W$10+'СК-2'!$O$10+'СК-3'!$P$8)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$L$10+'ХЭ-2'!$N$7+'ХЭ-3'!$T$8+'ХЭ-4'!$Y$8+'ХЭ-5'!$H$8+'ХЭ-5'!$N$8)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$10+'ФР-2'!$L$8)/2","v":{"v":5,"d":"5.0"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D91:H91)","v":25},{"$f":"SUM(D92:H92)","v":25}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G95/25","v":{"v":1,"d":"100%"}},{"$f":"H95/25","v":{"v":1,"d":"100%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G96","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C113>=80%,\"Высокий уровень\",IF(C113>=50%,\"Средний уровень\",IF(C113<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
[null,"к.г.",{"$f":"H96","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C114>=80%,\"Высокий уровень\",IF(C114>=50%,\"Средний уровень\",IF(C114<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":17}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C7","v":"Власов Дмитрий"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$10+'РР-2'!$Q$9+'РР-3'!$Y$9+'РР-4'!$R$9)/4","v":{"v":3.7056277056277054,"d":"3.7"}},{"$f":"('ПР-1'!$Y$11+'ПР-2'!$M$9)/2","v":{"v":3.8636363636363633,"d":"3.9"}},{"$f":"('СК-1'!$V$11+'СК-2'!$N$11+'СК-3'!$O$9)/3","v":{"v":3.8703703703703702,"d":"3.9"}},{"$f":"('ХЭ-1'!$K$11+'ХЭ-2'!$M$8+'ХЭ-3'!$S$9+'ХЭ-4'!$X$9+'ХЭ-5'!$G$9+'ХЭ-5'!$M$9)/6","v":{"v":3.8041666666666667,"d":"3.8"}},{"$f":"('ФР-1'!$S$11+'ФР-2'!$K$9)/2","v":{"v":3.4375,"d":"3.4"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$10+'РР-2'!$R$9+'РР-3'!$Z$9+'РР-4'!$S$9)/4","v":{"v":2.5122655122655124,"d":"2.5"}},{"$f":"('ПР-1'!$Z$11+'ПР-2'!$N$9)/2","v":{"v":2.618181818181818,"d":"2.6"}},{"$f":"('СК-1'!$W$11+'СК-2'!$O$11+'СК-3'!$P$9)/3","v":{"v":2.588888888888889,"d":"2.6"}},{"$f":"('ХЭ-1'!$L$11+'ХЭ-2'!$N$8+'ХЭ-3'!$T$9+'ХЭ-4'!$Y$9+'ХЭ-5'!$H$9+'ХЭ-5'!$N$8)/6","v":{"v":2.908333333333333,"d":"2.9"}},{"$f":"('ФР-1'!$T$11+'ФР-2'!$L$9)/2","v":{"v":2.375,"d":"2.4"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D136:H136)","v":{"v":18.681301106301106,"d":"19"}},{"$f":"SUM(D137:H137)","v":{"v":13.002669552669552,"d":"13"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G140/25","v":{"v":0.7472520442520443,"d":"75%"}},{"$f":"H140/25","v":{"v":0.5201067821067821,"d":"52%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G141","v":{"v":0.7472520442520443,"d":"75%"}},null,{"$f":"IF(C158>=80%,\"Высокий уровень\",IF(C158>=50%,\"Средний уровень\",IF(C158<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H141","v":{"v":0.5201067821067821,"d":"52%"}},null,{"$f":"IF(C159>=80%,\"Высокий уровень\",IF(C159>=50%,\"Средний уровень\",IF(C159<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":15}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C8","v":"Гущина Софья"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$11+'РР-2'!$Q$10+'РР-3'!$Y$10+'РР-4'!$R$10)/4","v":{"v":3.2438672438672436,"d":"3.2"}},{"$f":"('ПР-1'!$Y$12+'ПР-2'!$M$10)/2","v":{"v":3.290909090909091,"d":"3.3"}},{"$f":"('СК-1'!$V$12+'СК-2'!$N$12+'СК-3'!$O$10)/3","v":{"v":3.3185185185185184,"d":"3.3"}},{"$f":"('ХЭ-1'!$K$12+'ХЭ-2'!$M$9+'ХЭ-3'!$S$10+'ХЭ-4'!$X$10+'ХЭ-5'!$G$10+'ХЭ-5'!$M$10)/6","v":{"v":3.266666666666667,"d":"3.3"}},{"$f":"('ФР-1'!$S$12+'ФР-2'!$K$10)/2","v":{"v":3.25,"d":"3.3"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$11+'РР-2'!$R$10+'РР-3'!$Z$10+'РР-4'!$S$10)/4","v":{"v":4.243867243867244,"d":"4.2"}},{"$f":"('ПР-1'!$Z$12+'ПР-2'!$N$10)/2","v":{"v":4.290909090909091,"d":"4.3"}},{"$f":"('СК-1'!$W$12+'СК-2'!$O$12+'СК-3'!$P$10)/3","v":{"v":4.318518518518519,"d":"4.3"}},{"$f":"('ХЭ-1'!$L$12+'ХЭ-2'!$N$9+'ХЭ-3'!$T$10+'ХЭ-4'!$Y$10+'ХЭ-5'!$H$10+'ХЭ-5'!$N$10)/6","v":{"v":4.266666666666667,"d":"4.3"}},{"$f":"('ФР-1'!$T$12+'ФР-2'!$L$10)/2","v":{"v":4.25,"d":"4.3"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D179:H179)","v":{"v":16.36996151996152,"d":"16"}},{"$f":"SUM(D180:H180)","v":{"v":21.36996151996152,"d":"21"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G183/25","v":{"v":0.6547984607984608,"d":"65%"}},{"$f":"H183/25","v":{"v":0.8547984607984609,"d":"85%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G184","v":{"v":0.6547984607984608,"d":"65%"}},null,{"$f":"IF(C201>=80%,\"Высокий уровень\",IF(C201>=50%,\"Средний уровень\",IF(C201<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H184","v":{"v":0.8547984607984609,"d":"85%"}},null,{"$f":"IF(C202>=80%,\"Высокий уровень\",IF(C202>=50%,\"Средний уровень\",IF(C202<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":18}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C9","v":"Десятниченко Кирилл"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$12+'РР-2'!$Q$11+'РР-3'!$Y$11+'РР-4'!$R$11)/4","v":{"v":2.829365079365079,"d":"2.8"}},{"$f":"('ПР-1'!$Y$13+'ПР-2'!$M$11)/2","v":{"v":2.6545454545454543,"d":"2.7"}},{"$f":"('СК-1'!$V$13+'СК-2'!$N$13+'СК-3'!$O$11)/3","v":{"v":2.596296296296296,"d":"2.6"}},{"$f":"('ХЭ-1'!$K$13+'ХЭ-2'!$M$10+'ХЭ-3'!$S$11+'ХЭ-4'!$X$11+'ХЭ-5'!$G$11+'ХЭ-5'!$M$11)/6","v":{"v":2.7375000000000003,"d":"2.7"}},{"$f":"('ФР-1'!$S$13+'ФР-2'!$K$11)/2","v":{"v":3.1875,"d":"3.2"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$12+'РР-2'!$R$11+'РР-3'!$Z$11+'РР-4'!$S$11)/4","v":{"v":3.829365079365079,"d":"3.8"}},{"$f":"('ПР-1'!$Z$13+'ПР-2'!$N$11)/2","v":{"v":3.6545454545454543,"d":"3.7"}},{"$f":"('СК-1'!$W$13+'СК-2'!$O$13+'СК-3'!$P$11)/3","v":{"v":3.596296296296296,"d":"3.6"}},{"$f":"('ХЭ-1'!$L$13+'ХЭ-2'!$N$10+'ХЭ-3'!$T$11+'ХЭ-4'!$Y$11+'ХЭ-5'!$H$11+'ХЭ-5'!$N$11)/6","v":{"v":3.7375000000000003,"d":"3.7"}},{"$f":"('ФР-1'!$T$13+'ФР-2'!$L$11)/2","v":{"v":4.1875,"d":"4.2"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D225:H225)","v":{"v":14.00520683020683,"d":"14"}},{"$f":"SUM(D226:H226)","v":{"v":19.00520683020683,"d":"19"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G229/25","v":{"v":0.5602082732082733,"d":"56%"}},{"$f":"H229/25","v":{"v":0.7602082732082732,"d":"76%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G230","v":{"v":0.5602082732082733,"d":"56%"}},null,{"$f":"IF(C247>=80%,\"Высокий уровень\",IF(C247>=50%,\"Средний уровень\",IF(C247<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H230","v":{"v":0.7602082732082732,"d":"76%"}},null,{"$f":"IF(C248>=80%,\"Высокий уровень\",IF(C248>=50%,\"Средний уровень\",IF(C248<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":19}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C10","v":"Йолсал Дениз"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$13+'РР-2'!$Q$12+'РР-3'!$Y$12+'РР-4'!$R$12)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Y$14+'ПР-2'!$M$12)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$V$14+'СК-2'!$N$14+'СК-3'!$O$12)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$K$14+'ХЭ-2'!$M$11+'ХЭ-3'!$S$12+'ХЭ-4'!$X$12+'ХЭ-5'!$G$12+'ХЭ-5'!$M$12)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$14+'ФР-2'!$K$12)/2","v":{"v":5,"d":"5.0"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$13+'РР-2'!$R$12+'РР-3'!$Z$12+'РР-4'!$S$12)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Z$14+'ПР-2'!$N$12)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$W$14+'СК-2'!$O$14+'СК-3'!$P$12)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$L$14+'ХЭ-2'!$N$11+'ХЭ-3'!$T$12+'ХЭ-4'!$Y$12+'ХЭ-5'!$H$12+'ХЭ-5'!$N$12)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$14+'ФР-2'!$L$12)/2","v":{"v":5,"d":"5.0"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D272:H272)","v":25},{"$f":"SUM(D273:H273)","v":25}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G276/25","v":{"v":1,"d":"100%"}},{"$f":"H276/25","v":{"v":1,"d":"100%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G277","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C294>=80%,\"Высокий уровень\",IF(C294>=50%,\"Средний уровень\",IF(C294<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
[null,"к.г.",{"$f":"H277","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C295>=80%,\"Высокий уровень\",IF(C295>=50%,\"Средний уровень\",IF(C295<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C11","v":"Кирилина Виктория"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$14+'РР-2'!$Q$13+'РР-3'!$Y$13+'РР-4'!$R$13)/4","v":{"v":3.7056277056277054,"d":"3.7"}},{"$f":"('ПР-1'!$Y$15+'ПР-2'!$M$13)/2","v":{"v":3.8636363636363633,"d":"3.9"}},{"$f":"('СК-1'!$V$15+'СК-2'!$N$15+'СК-3'!$O$13)/3","v":{"v":3.8703703703703702,"d":"3.9"}},{"$f":"('ХЭ-1'!$K$15+'ХЭ-2'!$M$12+'ХЭ-3'!$S$13+'ХЭ-4'!$X$13+'ХЭ-5'!$G$13+'ХЭ-5'!$M$13)/6","v":{"v":3.8041666666666667,"d":"3.8"}},{"$f":"('ФР-1'!$S$15+'ФР-2'!$K$13)/2","v":{"v":3.4375,"d":"3.4"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$14+'РР-2'!$R$13+'РР-3'!$Z$13+'РР-4'!$S$13)/4","v":{"v":2.5122655122655124,"d":"2.5"}},{"$f":"('ПР-1'!$Z$15+'ПР-2'!$N$13)/2","v":{"v":2.618181818181818,"d":"2.6"}},{"$f":"('СК-1'!$W$15+'СК-2'!$O$15+'СК-3'!$P$13)/3","v":{"v":2.588888888888889,"d":"2.6"}},{"$f":"('ХЭ-1'!$L$15+'ХЭ-2'!$N$12+'ХЭ-3'!$T$13+'ХЭ-4'!$Y$13+'ХЭ-5'!$H$13+'ХЭ-5'!$N$13)/6","v":{"v":2.5749999999999997,"d":"2.6"}},{"$f":"('ФР-1'!$T$15+'ФР-2'!$L$13)/2","v":{"v":2.375,"d":"2.4"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D320:H320)","v":{"v":18.681301106301106,"d":"19"}},{"$f":"SUM(D321:H321)","v":{"v":12.669336219336218,"d":"13"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G324/25","v":{"v":0.7472520442520443,"d":"75%"}},{"$f":"H324/25","v":{"v":0.5067734487734488,"d":"51%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G325","v":{"v":0.7472520442520443,"d":"75%"}},null,{"$f":"IF(C342>=80%,\"Высокий уровень\",IF(C342>=50%,\"Средний уровень\",IF(C342<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H325","v":{"v":0.5067734487734488,"d":"51%"}},null,{"$f":"IF(C343>=80%,\"Высокий уровень\",IF(C343>=50%,\"Средний уровень\",IF(C343<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C12","v":"Князева Алиса"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$15+'РР-2'!$Q$14+'РР-3'!$Y$14+'РР-4'!$R$14)/4","v":{"v":3.2438672438672436,"d":"3.2"}},{"$f":"('ПР-1'!$Y$16+'ПР-2'!$M$14)/2","v":{"v":3.290909090909091,"d":"3.3"}},{"$f":"('СК-1'!$V$16+'СК-2'!$N$16+'СК-3'!$O$14)/3","v":{"v":3.3185185185185184,"d":"3.3"}},{"$f":"('ХЭ-1'!$K$16+'ХЭ-2'!$M$13+'ХЭ-3'!$S$14+'ХЭ-4'!$X$14+'ХЭ-5'!$G$14+'ХЭ-5'!$M$14)/6","v":{"v":3.266666666666667,"d":"3.3"}},{"$f":"('ФР-1'!$S$16+'ФР-2'!$K$14)/2","v":{"v":3.25,"d":"3.3"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$15+'РР-2'!$R$14+'РР-3'!$Z$14+'РР-4'!$S$14)/4","v":{"v":4.243867243867244,"d":"4.2"}},{"$f":"('ПР-1'!$Z$16+'ПР-2'!$N$14)/2","v":{"v":4.290909090909091,"d":"4.3"}},{"$f":"('СК-1'!$W$16+'СК-2'!$O$16+'СК-3'!$P$14)/3","v":{"v":4.318518518518519,"d":"4.3"}},{"$f":"('ХЭ-1'!$L$16+'ХЭ-2'!$N$13+'ХЭ-3'!$T$14+'ХЭ-4'!$Y$14+'ХЭ-5'!$H$14+'ХЭ-5'!$N$14)/6","v":{"v":4.266666666666667,"d":"4.3"}},{"$f":"('ФР-1'!$T$16+'ФР-2'!$L$14)/2","v":{"v":4.25,"d":"4.3"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D368:H368)","v":{"v":16.36996151996152,"d":"16"}},{"$f":"SUM(D369:H369)","v":{"v":21.36996151996152,"d":"21"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G372/25","v":{"v":0.6547984607984608,"d":"65%"}},{"$f":"H372/25","v":{"v":0.8547984607984609,"d":"85%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G373","v":{"v":0.6547984607984608,"d":"65%"}},null,{"$f":"IF(C390>=80%,\"Высокий уровень\",IF(C390>=50%,\"Средний уровень\",IF(C390<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H373","v":{"v":0.8547984607984609,"d":"85%"}},null,{"$f":"IF(C391>=80%,\"Высокий уровень\",IF(C391>=50%,\"Средний уровень\",IF(C391<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C13","v":"Максимова Анна"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$16+'РР-2'!$Q$15+'РР-3'!$Y$15+'РР-4'!$R$15)/4","v":{"v":2.829365079365079,"d":"2.8"}},{"$f":"('ПР-1'!$Y$17+'ПР-2'!$M$15)/2","v":{"v":2.6545454545454543,"d":"2.7"}},{"$f":"('СК-1'!$V$17+'СК-2'!$N$17+'СК-3'!$O$15)/3","v":{"v":2.596296296296296,"d":"2.6"}},{"$f":"('ХЭ-1'!$K$17+'ХЭ-2'!$M$14+'ХЭ-3'!$S$15+'ХЭ-4'!$X$15+'ХЭ-5'!$G$15+'ХЭ-5'!$M$15)/6","v":{"v":2.7375000000000003,"d":"2.7"}},{"$f":"('ФР-1'!$S$17+'ФР-2'!$K$15)/2","v":{"v":3.1875,"d":"3.2"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$16+'РР-2'!$R$15+'РР-3'!$Z$15+'РР-4'!$S$15)/4","v":{"v":3.829365079365079,"d":"3.8"}},{"$f":"('ПР-1'!$Z$17+'ПР-2'!$N$15)/2","v":{"v":3.6545454545454543,"d":"3.7"}},{"$f":"('СК-1'!$W$17+'СК-2'!$O$17+'СК-3'!$P$15)/3","v":{"v":3.596296296296296,"d":"3.6"}},{"$f":"('ХЭ-1'!$L$17+'ХЭ-2'!$N$14+'ХЭ-3'!$T$15+'ХЭ-4'!$Y$15+'ХЭ-5'!$H$15+'ХЭ-5'!$N$15)/6","v":{"v":3.7375000000000003,"d":"3.7"}},{"$f":"('ФР-1'!$T$17+'ФР-2'!$L$15)/2","v":{"v":4.1875,"d":"4.2"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D416:H416)","v":{"v":14.00520683020683,"d":"14"}},{"$f":"SUM(D417:H417)","v":{"v":19.00520683020683,"d":"19"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G420/25","v":{"v":0.5602082732082733,"d":"56%"}},{"$f":"H420/25","v":{"v":0.7602082732082732,"d":"76%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G421","v":{"v":0.5602082732082733,"d":"56%"}},null,{"$f":"IF(C438>=80%,\"Высокий уровень\",IF(C438>=50%,\"Средний уровень\",IF(C438<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H421","v":{"v":0.7602082732082732,"d":"76%"}},null,{"$f":"IF(C439>=80%,\"Высокий уровень\",IF(C439>=50%,\"Средний уровень\",IF(C439<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C14","v":"Меньшов Алексей"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$17+'РР-2'!$Q$16+'РР-3'!$Y$16+'РР-4'!$R$16)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Y$18+'ПР-2'!$M$16)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$V$18+'СК-2'!$N$18+'СК-3'!$O$16)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$K$18+'ХЭ-2'!$M$15+'ХЭ-3'!$S$16+'ХЭ-4'!$X$16+'ХЭ-5'!$G$16+'ХЭ-5'!$M$16)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$18+'ФР-2'!$K$16)/2","v":{"v":5,"d":"5.0"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$17+'РР-2'!$R$16+'РР-3'!$Z$16+'РР-4'!$S$16)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Z$18+'ПР-2'!$N$16)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$W$18+'СК-2'!$O$18+'СК-3'!$P$16)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$L$18+'ХЭ-2'!$N$15+'ХЭ-3'!$T$16+'ХЭ-4'!$Y$16+'ХЭ-5'!$H$16+'ХЭ-5'!$N$16)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$18+'ФР-2'!$L$16)/2","v":{"v":5,"d":"5.0"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D464:H464)","v":25},{"$f":"SUM(D465:H465)","v":25}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G468/25","v":{"v":1,"d":"100%"}},{"$f":"H468/25","v":{"v":1,"d":"100%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G469","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C486>=80%,\"Высокий уровень\",IF(C486>=50%,\"Средний уровень\",IF(C486<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
[null,"к.г.",{"$f":"H469","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C487>=80%,\"Высокий уровень\",IF(C487>=50%,\"Средний уровень\",IF(C487<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C15","v":"Муравлев Даниил"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$18+'РР-2'!$Q$17+'РР-3'!$Y$17+'РР-4'!$R$17)/4","v":{"v":3.7056277056277054,"d":"3.7"}},{"$f":"('ПР-1'!$Y$19+'ПР-2'!$M$17)/2","v":{"v":3.8636363636363633,"d":"3.9"}},{"$f":"('СК-1'!$V$19+'СК-2'!$N$19+'СК-3'!$O$17)/3","v":{"v":3.8703703703703702,"d":"3.9"}},{"$f":"('ХЭ-1'!$K$19+'ХЭ-2'!$M$16+'ХЭ-3'!$S$17+'ХЭ-4'!$X$17+'ХЭ-5'!$G$17+'ХЭ-5'!$M$17)/6","v":{"v":3.8041666666666667,"d":"3.8"}},{"$f":"('ФР-1'!$S$19+'ФР-2'!$K$17)/2","v":{"v":3.4375,"d":"3.4"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$18+'РР-2'!$R$17+'РР-3'!$Z$17+'РР-4'!$S$17)/4","v":{"v":2.5122655122655124,"d":"2.5"}},{"$f":"('ПР-1'!$Z$19+'ПР-2'!$N$17)/2","v":{"v":2.618181818181818,"d":"2.6"}},{"$f":"('СК-1'!$W$19+'СК-2'!$O$19+'СК-3'!$P$17)/3","v":{"v":2.588888888888889,"d":"2.6"}},{"$f":"('ХЭ-1'!$L$19+'ХЭ-2'!$N$16+'ХЭ-3'!$T$17+'ХЭ-4'!$Y$17+'ХЭ-5'!$H$17+'ХЭ-5'!$N$17)/6","v":{"v":2.5749999999999997,"d":"2.6"}},{"$f":"('ФР-1'!$T$19+'ФР-2'!$L$17)/2","v":{"v":2.375,"d":"2.4"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D512:H512)","v":{"v":18.681301106301106,"d":"19"}},{"$f":"SUM(D513:H513)","v":{"v":12.669336219336218,"d":"13"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G516/25","v":{"v":0.7472520442520443,"d":"75%"}},{"$f":"H516/25","v":{"v":0.5067734487734488,"d":"51%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G517","v":{"v":0.7472520442520443,"d":"75%"}},null,{"$f":"IF(C534>=80%,\"Высокий уровень\",IF(C534>=50%,\"Средний уровень\",IF(C534<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H517","v":{"v":0.5067734487734488,"d":"51%"}},null,{"$f":"IF(C535>=80%,\"Высокий уровень\",IF(C535>=50%,\"Средний уровень\",IF(C535<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C16","v":"Панов Тимофей "}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$19+'РР-2'!$Q$18+'РР-3'!$Y$18+'РР-4'!$R$18)/4","v":{"v":3.2438672438672436,"d":"3.2"}},{"$f":"('ПР-1'!$Y$20+'ПР-2'!$M$18)/2","v":{"v":3.290909090909091,"d":"3.3"}},{"$f":"('СК-1'!$V$20+'СК-2'!$N$20+'СК-3'!$O$18)/3","v":{"v":3.3185185185185184,"d":"3.3"}},{"$f":"('ХЭ-1'!$K$20+'ХЭ-2'!$M$17+'ХЭ-3'!$S$18+'ХЭ-4'!$X$18+'ХЭ-5'!$G$18+'ХЭ-5'!$M$18)/6","v":{"v":3.266666666666667,"d":"3.3"}},{"$f":"('ФР-1'!$S$20+'ФР-2'!$K$18)/2","v":{"v":3.25,"d":"3.3"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$19+'РР-2'!$R$18+'РР-3'!$Z$18+'РР-4'!$S$18)/4","v":{"v":4.243867243867244,"d":"4.2"}},{"$f":"('ПР-1'!$Z$20+'ПР-2'!$N$18)/2","v":{"v":4.290909090909091,"d":"4.3"}},{"$f":"('СК-1'!$W$20+'СК-2'!$O$20+'СК-3'!$P$18)/3","v":{"v":4.318518518518519,"d":"4.3"}},{"$f":"('ХЭ-1'!$L$20+'ХЭ-2'!$N$17+'ХЭ-3'!$T$18+'ХЭ-4'!$Y$18+'ХЭ-5'!$H$18+'ХЭ-5'!$N$18)/6","v":{"v":4.266666666666667,"d":"4.3"}},{"$f":"('ФР-1'!$T$20+'ФР-2'!$L$18)/2","v":{"v":4.25,"d":"4.3"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D560:H560)","v":{"v":16.36996151996152,"d":"16"}},{"$f":"SUM(D561:H561)","v":{"v":21.36996151996152,"d":"21"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G564/25","v":{"v":0.6547984607984608,"d":"65%"}},{"$f":"H564/25","v":{"v":0.8547984607984609,"d":"85%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G565","v":{"v":0.6547984607984608,"d":"65%"}},null,{"$f":"IF(C582>=80%,\"Высокий уровень\",IF(C582>=50%,\"Средний уровень\",IF(C582<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H565","v":{"v":0.8547984607984609,"d":"85%"}},null,{"$f":"IF(C583>=80%,\"Высокий уровень\",IF(C583>=50%,\"Средний уровень\",IF(C583<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C17","v":"Саркисов Илья "}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$20+'РР-2'!$Q$19+'РР-3'!$Y$19+'РР-4'!$R$19)/4","v":{"v":2.829365079365079,"d":"2.8"}},{"$f":"('ПР-1'!$Y$21+'ПР-2'!$M$19)/2","v":{"v":2.6545454545454543,"d":"2.7"}},{"$f":"('СК-1'!$V$21+'СК-2'!$N$21+'СК-3'!$O$19)/3","v":{"v":2.596296296296296,"d":"2.6"}},{"$f":"('ХЭ-1'!$K$21+'ХЭ-2'!$M$18+'ХЭ-3'!$S$19+'ХЭ-4'!$X$19+'ХЭ-5'!$G$19+'ХЭ-5'!$M$19)/6","v":{"v":2.7375000000000003,"d":"2.7"}},{"$f":"('ФР-1'!$S$21+'ФР-2'!$K$19)/2","v":{"v":3.1875,"d":"3.2"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$20+'РР-2'!$R$19+'РР-3'!$Z$19+'РР-4'!$S$19)/4","v":{"v":3.829365079365079,"d":"3.8"}},{"$f":"('ПР-1'!$Z$21+'ПР-2'!$N$19)/2","v":{"v":3.6545454545454543,"d":"3.7"}},{"$f":"('СК-1'!$W$21+'СК-2'!$O$21+'СК-3'!$P$19)/3","v":{"v":3.596296296296296,"d":"3.6"}},{"$f":"('ХЭ-1'!$L$21+'ХЭ-2'!$N$18+'ХЭ-3'!$T$19+'ХЭ-4'!$Y$19+'ХЭ-5'!$H$19+'ХЭ-5'!$N$19)/6","v":{"v":3.7375000000000003,"d":"3.7"}},{"$f":"('ФР-1'!$T$21+'ФР-2'!$L$19)/2","v":{"v":4.1875,"d":"4.2"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D608:H608)","v":{"v":14.00520683020683,"d":"14"}},{"$f":"SUM(D609:H609)","v":{"v":19.00520683020683,"d":"19"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G612/25","v":{"v":0.5602082732082733,"d":"56%"}},{"$f":"H612/25","v":{"v":0.7602082732082732,"d":"76%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G613","v":{"v":0.5602082732082733,"d":"56%"}},null,{"$f":"IF(C630>=80%,\"Высокий уровень\",IF(C630>=50%,\"Средний уровень\",IF(C630<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H613","v":{"v":0.7602082732082732,"d":"76%"}},null,{"$f":"IF(C631>=80%,\"Высокий уровень\",IF(C631>=50%,\"Средний уровень\",IF(C631<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C18","v":"Свирская Анастасия "}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$21+'РР-2'!$Q$20+'РР-3'!$Y$20+'РР-4'!$R$20)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Y$22+'ПР-2'!$M$20)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$V$22+'СК-2'!$N$22+'СК-3'!$O$20)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$K$22+'ХЭ-2'!$M$19+'ХЭ-3'!$S$20+'ХЭ-4'!$X$20+'ХЭ-5'!$G$20+'ХЭ-5'!$M$20)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$22+'ФР-2'!$K$20)/2","v":{"v":5,"d":"5.0"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$21+'РР-2'!$R$20+'РР-3'!$Z$20+'РР-4'!$S$20)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Z$22+'ПР-2'!$N$20)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$W$22+'СК-2'!$O$22+'СК-3'!$P$20)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$L$22+'ХЭ-2'!$N$19+'ХЭ-3'!$T$20+'ХЭ-4'!$Y$20+'ХЭ-5'!$H$20+'ХЭ-5'!$N$20)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$22+'ФР-2'!$L$20)/2","v":{"v":5,"d":"5.0"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D656:H656)","v":25},{"$f":"SUM(D657:H657)","v":25}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G660/25","v":{"v":1,"d":"100%"}},{"$f":"H660/25","v":{"v":1,"d":"100%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G661","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C678>=80%,\"Высокий уровень\",IF(C678>=50%,\"Средний уровень\",IF(C678<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
[null,"к.г.",{"$f":"H661","v":{"v":1,"d":"100%"}},null,{"$f":"IF(C679>=80%,\"Высокий уровень\",IF(C679>=50%,\"Средний уровень\",IF(C679<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!C19","v":"Семенина Елизавета"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$22+'РР-2'!$Q$21+'РР-3'!$Y$21+'РР-4'!$R$21)/4","v":{"v":3.7056277056277054,"d":"3.7"}},{"$f":"('ПР-1'!$Y$23+'ПР-2'!$M$21)/2","v":{"v":3.8636363636363633,"d":"3.9"}},{"$f":"('СК-1'!$V$23+'СК-2'!$N$23+'СК-3'!$O$21)/3","v":{"v":3.8703703703703702,"d":"3.9"}},{"$f":"('ХЭ-1'!$K$22+'ХЭ-2'!$M$19+'ХЭ-3'!$S$20+'ХЭ-4'!$X$20+'ХЭ-5'!$G$20+'ХЭ-5'!$M$20)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$23+'ФР-2'!$K$21)/2","v":{"v":3.4375,"d":"3.4"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$22+'РР-2'!$R$21+'РР-3'!$Z$21+'РР-4'!$S$21)/4","v":{"v":2.5122655122655124,"d":"2.5"}},{"$f":"('ПР-1'!$Z$23+'ПР-2'!$N$21)/2","v":{"v":2.618181818181818,"d":"2.6"}},{"$f":"('СК-1'!$W$23+'СК-2'!$O$23+'СК-3'!$P$21)/3","v":{"v":2.588888888888889,"d":"2.6"}},{"$f":"('ХЭ-1'!$L$22+'ХЭ-2'!$N$19+'ХЭ-3'!$T$20+'ХЭ-4'!$Y$20+'ХЭ-5'!$H$20+'ХЭ-5'!$N$20)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$23+'ФР-2'!$L$21)/2","v":{"v":2.375,"d":"2.4"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D704:H704)","v":{"v":19.87713443963444,"d":"20"}},{"$f":"SUM(D705:H705)","v":{"v":15.094336219336219,"d":"15"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G708/25","v":{"v":0.7950853775853776,"d":"80%"}},{"$f":"H708/25","v":{"v":0.6037734487734487,"d":"60%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G709","v":{"v":0.7950853775853776,"d":"80%"}},null,{"$f":"IF(C726>=80%,\"Высокий уровень\",IF(C726>=50%,\"Средний уровень\",IF(C726<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H709","v":{"v":0.6037734487734487,"d":"60%"}},null,{"$f":"IF(C727>=80%,\"Высокий уровень\",IF(C727>=50%,\"Средний уровень\",IF(C727<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$20","v":"Сергеев Алексей"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$23+'РР-2'!$Q$22+'РР-3'!$Y$22+'РР-4'!$R$22)/4","v":{"v":3.2438672438672436,"d":"3.2"}},{"$f":"('ПР-1'!$Y$24+'ПР-2'!$M$22)/2","v":{"v":3.290909090909091,"d":"3.3"}},{"$f":"('СК-1'!$V$24+'СК-2'!$N$24+'СК-3'!$O$22)/3","v":{"v":3.3185185185185184,"d":"3.3"}},{"$f":"('ХЭ-1'!$K$23+'ХЭ-2'!$M$20+'ХЭ-3'!$S$21+'ХЭ-4'!$X$21+'ХЭ-5'!$G$21+'ХЭ-5'!$M$21)/6","v":{"v":3.8041666666666667,"d":"3.8"}},{"$f":"('ФР-1'!$S$24+'ФР-2'!$K$24)/2","v":{"v":4.125,"d":"4.1"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$23+'РР-2'!$R$22+'РР-3'!$Z$22+'РР-4'!$S$22)/4","v":{"v":4.243867243867244,"d":"4.2"}},{"$f":"('ПР-1'!$Z$24+'ПР-2'!$N$22)/2","v":{"v":4.290909090909091,"d":"4.3"}},{"$f":"('СК-1'!$W$24+'СК-2'!$O$24+'СК-3'!$P$22)/3","v":{"v":4.318518518518519,"d":"4.3"}},{"$f":"('ХЭ-1'!$L$24+'ХЭ-2'!$N$20+'ХЭ-3'!$T$21+'ХЭ-4'!$Y$21+'ХЭ-5'!$H$21+'ХЭ-5'!$N$21)/6","v":{"v":2.8249999999999997,"d":"2.8"}},{"$f":"('ФР-1'!$T$24+'ФР-2'!$L$24)/2","v":{"v":4.625,"d":"4.6"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D752:H752)","v":{"v":17.782461519961522,"d":"18"}},{"$f":"SUM(D753:H753)","v":{"v":20.303294853294855,"d":"20"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G756/25","v":{"v":0.7112984607984609,"d":"71%"}},{"$f":"H756/25","v":{"v":0.8121317941317941,"d":"81%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G757","v":{"v":0.7112984607984609,"d":"71%"}},null,{"$f":"IF(C774>=80%,\"Высокий уровень\",IF(C774>=50%,\"Средний уровень\",IF(C774<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H757","v":{"v":0.8121317941317941,"d":"81%"}},null,{"$f":"IF(C775>=80%,\"Высокий уровень\",IF(C775>=50%,\"Средний уровень\",IF(C775<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$21","v":"Солопов Максим"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$24+'РР-2'!$Q$23+'РР-3'!$Y$23+'РР-4'!$R$23)/4","v":{"v":2.829365079365079,"d":"2.8"}},{"$f":"('ПР-1'!$Y$25+'ПР-2'!$M$23)/2","v":{"v":2.6545454545454543,"d":"2.7"}},{"$f":"('СК-1'!$V$25+'СК-2'!$N$25+'СК-3'!$O$23)/3","v":{"v":2.596296296296296,"d":"2.6"}},{"$f":"('ХЭ-1'!$K$24+'ХЭ-2'!$M$21+'ХЭ-3'!$S$22+'ХЭ-4'!$X$22+'ХЭ-5'!$G$22+'ХЭ-5'!$M$22)/6","v":{"v":3.266666666666667,"d":"3.3"}},{"$f":"('ФР-1'!$S$25+'ФР-2'!$K$23)/2","v":{"v":3.1875,"d":"3.2"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$24+'РР-2'!$R$23+'РР-3'!$Z$23+'РР-4'!$S$23)/4","v":{"v":3.829365079365079,"d":"3.8"}},{"$f":"('ПР-1'!$Z$25+'ПР-2'!$N$23)/2","v":{"v":3.6545454545454543,"d":"3.7"}},{"$f":"('СК-1'!$W$25+'СК-2'!$O$25+'СК-3'!$P$23)/3","v":{"v":3.596296296296296,"d":"3.6"}},{"$f":"('ХЭ-1'!$L$24+'ХЭ-2'!$N$21+'ХЭ-3'!$T$22+'ХЭ-4'!$Y$22+'ХЭ-5'!$H$22+'ХЭ-5'!$N$22)/6","v":{"v":4.266666666666667,"d":"4.3"}},{"$f":"('ФР-1'!$T$25+'ФР-2'!$L$23)/2","v":{"v":4.1875,"d":"4.2"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D800:H800)","v":{"v":14.534373496873497,"d":"15"}},{"$f":"SUM(D801:H801)","v":{"v":19.534373496873496,"d":"20"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G804/25","v":{"v":0.5813749398749399,"d":"58%"}},{"$f":"H804/25","v":{"v":0.7813749398749398,"d":"78%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G805","v":{"v":0.5813749398749399,"d":"58%"}},null,{"$f":"IF(C822>=80%,\"Высокий уровень\",IF(C822>=50%,\"Средний уровень\",IF(C822<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H805","v":{"v":0.7813749398749398,"d":"78%"}},null,{"$f":"IF(C823>=80%,\"Высокий уровень\",IF(C823>=50%,\"Средний уровень\",IF(C823<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$22","v":"Стригунов Александр "}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$25+'РР-2'!$Q$24+'РР-3'!$Y$24+'РР-4'!$R$24)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Y$26+'ПР-2'!$M$24)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$V$26+'СК-2'!$N$26+'СК-3'!$O$24)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$K$25+'ХЭ-2'!$M$22+'ХЭ-3'!$S$23+'ХЭ-4'!$X$23+'ХЭ-5'!$G$23+'ХЭ-5'!$M$23)/6","v":{"v":2.7375000000000003,"d":"2.7"}},{"$f":"('ФР-1'!$S$26+'ФР-2'!$K$24)/2","v":{"v":5,"d":"5.0"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$25+'РР-2'!$R$24+'РР-3'!$Z$24+'РР-4'!$S$24)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Z$26+'ПР-2'!$N$24)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$W$26+'СК-2'!$O$26+'СК-3'!$P$24)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$L$25+'ХЭ-2'!$N$22+'ХЭ-3'!$T$23+'ХЭ-4'!$Y$23+'ХЭ-5'!$H$23+'ХЭ-5'!$N$23)/6","v":{"v":3.7375000000000003,"d":"3.7"}},{"$f":"('ФР-1'!$T$26+'ФР-2'!$L$24)/2","v":{"v":5,"d":"5.0"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D848:H848)","v":{"v":22.7375,"d":"23"}},{"$f":"SUM(D849:H849)","v":{"v":23.7375,"d":"24"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G852/25","v":{"v":0.9095,"d":"91%"}},{"$f":"H852/25","v":{"v":0.9495,"d":"95%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G853","v":{"v":0.9095,"d":"91%"}},null,{"$f":"IF(C870>=80%,\"Высокий уровень\",IF(C870>=50%,\"Средний уровень\",IF(C870<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
[null,"к.г.",{"$f":"H853","v":{"v":0.9495,"d":"95%"}},null,{"$f":"IF(C871>=80%,\"Высокий уровень\",IF(C871>=50%,\"Средний уровень\",IF(C871<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$23","v":"Тихонов Данил"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$26+'РР-2'!$Q$25+'РР-3'!$Y$25+'РР-4'!$R$25)/4","v":{"v":3.7056277056277054,"d":"3.7"}},{"$f":"('ПР-1'!$Y$27+'ПР-2'!$M$25)/2","v":{"v":3.8636363636363633,"d":"3.9"}},{"$f":"('СК-1'!$V$27+'СК-2'!$N$27+'СК-3'!$O$25)/3","v":{"v":3.8703703703703702,"d":"3.9"}},{"$f":"('ХЭ-1'!$K$26+'ХЭ-2'!$M$23+'ХЭ-3'!$S$24+'ХЭ-4'!$X$24+'ХЭ-5'!$G$24+'ХЭ-5'!$M$24)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$27+'ФР-2'!$K$25)/2","v":{"v":3.4375,"d":"3.4"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$26+'РР-2'!$R$25+'РР-3'!$Z$25+'РР-4'!$S$25)/4","v":{"v":2.5122655122655124,"d":"2.5"}},{"$f":"('ПР-1'!$Z$27+'ПР-2'!$N$25)/2","v":{"v":2.618181818181818,"d":"2.6"}},{"$f":"('СК-1'!$W$27+'СК-2'!$O$27+'СК-3'!$P$25)/3","v":{"v":2.588888888888889,"d":"2.6"}},{"$f":"('ХЭ-1'!$L$26+'ХЭ-2'!$N$23+'ХЭ-3'!$T$24+'ХЭ-4'!$Y$24+'ХЭ-5'!$H$24+'ХЭ-5'!$N$24)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$27+'ФР-2'!$L$25)/2","v":{"v":2.375,"d":"2.4"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D896:H896)","v":{"v":19.87713443963444,"d":"20"}},{"$f":"SUM(D897:H897)","v":{"v":15.094336219336219,"d":"15"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G900/25","v":{"v":0.7950853775853776,"d":"80%"}},{"$f":"H900/25","v":{"v":0.6037734487734487,"d":"60%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G901","v":{"v":0.7950853775853776,"d":"80%"}},null,{"$f":"IF(C918>=80%,\"Высокий уровень\",IF(C918>=50%,\"Средний уровень\",IF(C918<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H901","v":{"v":0.6037734487734487,"d":"60%"}},null,{"$f":"IF(C919>=80%,\"Высокий уровень\",IF(C919>=50%,\"Средний уровень\",IF(C919<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$24","v":"Федоров Данила"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$27+'РР-2'!$Q$26+'РР-3'!$Y$26+'РР-4'!$R$26)/4","v":{"v":3.2438672438672436,"d":"3.2"}},{"$f":"('ПР-1'!$Y$28+'ПР-2'!$M$26)/2","v":{"v":3.290909090909091,"d":"3.3"}},{"$f":"('СК-1'!$V$28+'СК-2'!$N$28+'СК-3'!$O$26)/3","v":{"v":3.3185185185185184,"d":"3.3"}},{"$f":"('ХЭ-1'!$K$27+'ХЭ-2'!$M$24+'ХЭ-3'!$S$25+'ХЭ-4'!$X$25+'ХЭ-5'!$G$25+'ХЭ-5'!$M$25)/6","v":{"v":3.8041666666666667,"d":"3.8"}},{"$f":"('ФР-1'!$S$28+'ФР-2'!$K$26)/2","v":{"v":3.25,"d":"3.3"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$27+'РР-2'!$R$26+'РР-3'!$Z$26+'РР-4'!$S$26)/4","v":{"v":4.243867243867244,"d":"4.2"}},{"$f":"('ПР-1'!$Z$28+'ПР-2'!$N$26)/2","v":{"v":4.290909090909091,"d":"4.3"}},{"$f":"('СК-1'!$W$28+'СК-2'!$O$28+'СК-3'!$P$26)/3","v":{"v":4.318518518518519,"d":"4.3"}},{"$f":"('ХЭ-1'!$L$27+'ХЭ-2'!$N$24+'ХЭ-3'!$T$25+'ХЭ-4'!$Y$25+'ХЭ-5'!$H$25+'ХЭ-5'!$N$25)/6","v":{"v":2.5749999999999997,"d":"2.6"}},{"$f":"('ФР-1'!$T$28+'ФР-2'!$L$26)/2","v":{"v":4.25,"d":"4.3"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D944:H944)","v":{"v":16.907461519961522,"d":"17"}},{"$f":"SUM(D945:H945)","v":{"v":19.678294853294855,"d":"20"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G948/25","v":{"v":0.6762984607984609,"d":"68%"}},{"$f":"H948/25","v":{"v":0.7871317941317941,"d":"79%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G949","v":{"v":0.6762984607984609,"d":"68%"}},null,{"$f":"IF(C966>=80%,\"Высокий уровень\",IF(C966>=50%,\"Средний уровень\",IF(C966<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H949","v":{"v":0.7871317941317941,"d":"79%"}},null,{"$f":"IF(C967>=80%,\"Высокий уровень\",IF(C967>=50%,\"Средний уровень\",IF(C967<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$25","v":"Чалдина Дарья"}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$28+'РР-2'!$Q$27+'РР-3'!$Y$27+'РР-4'!$R$27)/4","v":{"v":2.829365079365079,"d":"2.8"}},{"$f":"('ПР-1'!$Y$29+'ПР-2'!$M$27)/2","v":{"v":2.6545454545454543,"d":"2.7"}},{"$f":"('СК-1'!$V$29+'СК-2'!$N$29+'СК-3'!$O$27)/3","v":{"v":2.596296296296296,"d":"2.6"}},{"$f":"('ХЭ-1'!$K$28+'ХЭ-2'!$M$25+'ХЭ-3'!$S$26+'ХЭ-4'!$X$26+'ХЭ-5'!$G$26+'ХЭ-5'!$M$26)/6","v":{"v":3.266666666666667,"d":"3.3"}},{"$f":"('ФР-1'!$S$29+'ФР-2'!$K$27)/2","v":{"v":3.1875,"d":"3.2"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$28+'РР-2'!$R$27+'РР-3'!$Z$27+'РР-4'!$S$27)/4","v":{"v":3.829365079365079,"d":"3.8"}},{"$f":"('ПР-1'!$Z$29+'ПР-2'!$N$27)/2","v":{"v":3.6545454545454543,"d":"3.7"}},{"$f":"('СК-1'!$W$29+'СК-2'!$O$29+'СК-3'!$P$27)/3","v":{"v":3.596296296296296,"d":"3.6"}},{"$f":"('ХЭ-1'!$L$28+'ХЭ-2'!$N$25+'ХЭ-3'!$T$26+'ХЭ-4'!$Y$26+'ХЭ-5'!$H$26+'ХЭ-5'!$N$26)/6","v":{"v":4.266666666666667,"d":"4.3"}},{"$f":"('ФР-1'!$T$29+'ФР-2'!$L$27)/2","v":{"v":4.1875,"d":"4.2"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D992:H992)","v":{"v":14.534373496873497,"d":"15"}},{"$f":"SUM(D993:H993)","v":{"v":19.534373496873496,"d":"20"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G996/25","v":{"v":0.5813749398749399,"d":"58%"}},{"$f":"H996/25","v":{"v":0.7813749398749398,"d":"78%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G997","v":{"v":0.5813749398749399,"d":"58%"}},null,{"$f":"IF(C1014>=80%,\"Высокий уровень\",IF(C1014>=50%,\"Средний уровень\",IF(C1014<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H997","v":{"v":0.7813749398749398,"d":"78%"}},null,{"$f":"IF(C1015>=80%,\"Высокий уровень\",IF(C1015>=50%,\"Средний уровень\",IF(C1015<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$26","v":"Черногоров Аркадий "}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$29+'РР-2'!$Q$28+'РР-3'!$Y$28+'РР-4'!$R$28)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Y$30+'ПР-2'!$M$28)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$V$30+'СК-2'!$N$30+'СК-3'!$O$28)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$K$29+'ХЭ-2'!$M$26+'ХЭ-3'!$S$27+'ХЭ-4'!$X$27+'ХЭ-5'!$G$27+'ХЭ-5'!$M$27)/6","v":{"v":2.7375000000000003,"d":"2.7"}},{"$f":"('ФР-1'!$S$30+'ФР-2'!$K$28)/2","v":{"v":5,"d":"5.0"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$29+'РР-2'!$R$28+'РР-3'!$Z$28+'РР-4'!$S$28)/4","v":{"v":5,"d":"5.0"}},{"$f":"('ПР-1'!$Z$30+'ПР-2'!$N$28)/2","v":{"v":5,"d":"5.0"}},{"$f":"('СК-1'!$W$30+'СК-2'!$O$30+'СК-3'!$P$28)/3","v":{"v":5,"d":"5.0"}},{"$f":"('ХЭ-1'!$L$29+'ХЭ-2'!$N$26+'ХЭ-3'!$T$27+'ХЭ-4'!$Y$27+'ХЭ-5'!$H$27+'ХЭ-5'!$N$27)/6","v":{"v":3.7375000000000003,"d":"3.7"}},{"$f":"('ФР-1'!$T$30+'ФР-2'!$L$28)/2","v":{"v":5,"d":"5.0"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D1040:H1040)","v":{"v":22.7375,"d":"23"}},{"$f":"SUM(D1041:H1041)","v":{"v":23.7375,"d":"24"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G1044/25","v":{"v":0.9095,"d":"91%"}},{"$f":"H1044/25","v":{"v":0.9495,"d":"95%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G1045","v":{"v":0.9095,"d":"91%"}},null,{"$f":"IF(C1062>=80%,\"Высокий уровень\",IF(C1062>=50%,\"Средний уровень\",IF(C1062<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
[null,"к.г.",{"$f":"H1045","v":{"v":0.9495,"d":"95%"}},null,{"$f":"IF(C1063>=80%,\"Высокий уровень\",IF(C1063>=50%,\"Средний уровень\",IF(C1063<49%,\"Низкий уровень\")))","v":"Высокий уровень"}]
{"$rows_empty":20}
["О","ФИ ребенка:",null,{"$f":"'Список группы'!$C$27","v":"Шагабудинов Владислав "}]
[]
[null,"Сводна таблица",null,"Речевое развитие","Познавательное развитие","Социально-коммуникативное развитие","Художественно-эстетическое развитие","Физическое развитие"]
[{"$nulls":3},"РР","ПР","СК","ХЭ","ФР"]
[null,"Н.Г.",null,{"$f":"('РР-1'!$U$30+'РР-2'!$Q$29+'РР-3'!$Y$29+'РР-4'!$R$29)/4","v":{"v":3.7056277056277054,"d":"3.7"}},{"$f":"('ПР-1'!$Y$31+'ПР-2'!$M$29)/2","v":{"v":3.8636363636363633,"d":"3.9"}},{"$f":"('СК-1'!$V$31+'СК-2'!$N$31+'СК-3'!$O$29)/3","v":{"v":3.8703703703703702,"d":"3.9"}},{"$f":"('ХЭ-1'!$K$30+'ХЭ-2'!$M$27+'ХЭ-3'!$S$28+'ХЭ-4'!$X$28+'ХЭ-5'!$G$28+'ХЭ-5'!$M$28)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$S$31+'ФР-2'!$K$29)/2","v":{"v":3.4375,"d":"3.4"}}]
[null,"К.Г.",null,{"$f":"('РР-1'!$V$30+'РР-2'!$R$29+'РР-3'!$Z$29+'РР-4'!$S$29)/4","v":{"v":2.5122655122655124,"d":"2.5"}},{"$f":"('ПР-1'!$Z$31+'ПР-2'!$N$29)/2","v":{"v":2.618181818181818,"d":"2.6"}},{"$f":"('СК-1'!$W$31+'СК-2'!$O$31+'СК-3'!$P$29)/3","v":{"v":2.588888888888889,"d":"2.6"}},{"$f":"('ХЭ-1'!$L$30+'ХЭ-2'!$N$27+'ХЭ-3'!$T$28+'ХЭ-4'!$Y$28+'ХЭ-5'!$H$28+'ХЭ-5'!$N$28)/6","v":{"v":5,"d":"5.0"}},{"$f":"('ФР-1'!$T$31+'ФР-2'!$L$29)/2","v":{"v":2.375,"d":"2.4"}}]
[]
[{"$nulls":6},"Сентябрь","Май"]
[null,"Итоговое количество баллов по блоку (макс.25)",{"$nulls":4},{"$f":"SUM(D1088:H1088)","v":{"v":19.87713443963444,"d":"20"}},{"$f":"SUM(D1089:H1089)","v":{"v":15.094336219336219,"d":"15"}}]
[null,"Уровень успешности образовательной деятельности",{"$nulls":4},{"$f":"G1092/25","v":{"v":0.7950853775853776,"d":"80%"}},{"$f":"H1092/25","v":{"v":0.6037734487734487,"d":"60%"}}]
{"$rows_empty":15}
[null,"Уровень успешности образовательной деятельности по отношению к обучающемуся"]
[null,"н.г.",{"$f":"G1093","v":{"v":0.7950853775853776,"d":"80%"}},null,{"$f":"IF(C1110>=80%,\"Высокий уровень\",IF(C1110>=50%,\"Средний уровень\",IF(C1110<49%,\"Низкий уровень\")))","v":"Средний уровень"}]
[null,"к.г.",{"$f":"H1093","v":{"v":0.6037734487734487,"d":"60%"}},null,{"$f":"IF(C1111>=80%,\"Высокий уровень\",IF(C1111>=50%,\"Средний уровень\",IF(C1111<49%,\"Низкий уровень\")))","v":"Средний уровень"}]